TRUNCATE

 CREATE DATABASE cricket;

USE cricket;

CREATE TABLE info( jersey INT PRIMARY KEY,name VARCHAR(50),team VARCHAR(50),nickname VARCHAR(77));

INSERT INTO info 

VALUES(7,'dhoni','csk','thala'),

(3,'raina','csk','mr.ipl'),

(8,'jaddu','csk,','bestf'),

(18,'kohli','rcb','king');

SELECT * FROM info;

TRUNCATE info;