MySql常用SQL

1.Add Column: alter table icecream add column flavor varchar (20) ; 

2.Change Column: alter table tablename change oldname newname varchar (10) ;

3.Delete Column:  alter table icecream drop column flavor; 

4.Disable FK: SET foreign_key_checks = 0;