BASIC STATEMENT
CHANGE COLUMN DATA TYPE1
ALTER TABLE TB_NAME CHANGE COL1 COL2 INT
DELETE COLUMN1
ALTER TABLE TB_NAME DROP COL_NAME
RESET AUTO_INCREMENT1
ALTER TABLE TB_NAME AUTO_INCREMENT=0
CHANGE COLUMN DATA TYPE1
ALTER TABLE TB_NAME CHANGE COL1 COL2 INT
DELETE COLUMN1
ALTER TABLE TB_NAME DROP COL_NAME
RESET AUTO_INCREMENT1
ALTER TABLE TB_NAME AUTO_INCREMENT=0
Update your browser to view this website correctly. Update my browser now
Comments