语法
添加列
ALTER TABLE table_name ADD COLUMN column_name column_defination;
ALTER TABLE table_name ADD COLUMN column_name column_defination AFTER id;
删除列
ALTER TABLE table_name DROP COLUMN column_name;
修改列
ALTER TABLE table_name CHANGE column_name new_column_name column_defination;
实例
创建数据表
CREATE TABLE test(
id SMALLINT PRIMARY KEY AUTO_INCREMENT,
name varchar(10) NOT NULL
)DEFAULT CHARSET=utf8;
添加一行性别列
ALTER TABLE test ADD COLUMN sex TINYINT NOT NULL AFTER id;
修改性别列
ALTER TABLE test CHANGE sex sex varchar(4);
删除性别列
ALTER TABLE test DROP COLUMN sex;