ExpertRefresh

Administration / Add column  

1) Which is wrong when adding a new field?





2) How do you add a column after another?







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



n/a