minte9
LearnRemember   MYSQL





Add column 

 
ALTER TABLE mytable ADD myemail varchar(30);
ALTER TABLE mytable ADD COLUMN myaddress varchar(30);

Add column (after / before) 

 
ALTER TABLE mytable ADD COLUMN myphone varchar(30) AFTER myname;
ALTER TABLE mytable ADD COLUMN id2 int(11) FIRST;

Alter column 

 
ALTER TABLE mytable CHANGE COLUMN myname myname_new  int(11);

Drop column 

 
ALTER TABLE mytable DROP  COLUMN id2;




References: