MySQL添加删除字段修改表结构

1.MySQL添加字段

ALTER TABLE student 
ADD COLUMN age INT NOT NULL DEFAULT 0
AFTER name

2.删除字段

ALTER TABLE student
DROP COLUMN age

3.调整字段顺序

ALTER TABLE student
CHANGE age age INT NOT NULL DEFAULT 0
AFTER id

4.重命名列

ALTER TABLE student 
CHANGE age age1

5.重命名表

ALTER TABLE student
RENAME student1