MemoryRefresh!

Administration / Add column     Add column



Questions 1 Answers 0%

Pages   0 from 12
Questions   0 from 14

Reset


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





Programming

Php
   
Regex
   
MySQL
   
Css
   
jQuery
   
Git
   


References
n/a