添加、修改、删除列操作

语法

添加列

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;