PROGRAMMING

 
REMEMBERS




Last update:   29-10-2021

Add column

 
ALTER TABLE mytable ADD myemail varchar(30);
ALTER TABLE mytable ADD COLUMN myaddress varchar(30);
Add Column (after    (2/4)

Add column (after

 
ALTER TABLE mytable ADD COLUMN myphone varchar(30) AFTER myname;
ALTER TABLE mytable ADD COLUMN id2 int(11) FIRST;
Alter Column    (3/4)

Alter column

 
ALTER TABLE mytable CHANGE COLUMN myname myname_new  int(11);
Drop Column    (4/4)

Drop column

 
ALTER TABLE mytable DROP  COLUMN id2;

Questions    
Add index

        A B C D E F
🔔
1/4