ALTER OPERATIONS

 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');

ALTER TABLE info

ADD COLUMN trophies INT;

SELECT * FROM info;

show tables;

ALTER TABLE info 

RENAME TO ipl;

ALTER TABLE ipl

CHANGE COLUMN trophies winners int;

ALTER TABLE ipl

MODIFY winners VARCHAR(50);

ALTER TABLE ipl

DROP COLUMN winners;