Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # 增加一个字段
- ALTER TABLE people ADD COLUMN name VARCHAR(100) DEFAULT NULL COMMENT '姓名'
- # 增加多个字段
- alter table test add (c1 char(1),c2 char(1)); --正确,add支持多列
- alter table test add column (c1 char(1),c2 char(1)); --正确
- alter table test add c1 char(1),add c2 char(1); --正确
- --修改多列
- alter table test change c1 c3 char(1),change c2 c4 char(1); --正确
- alter table test change column c1 c3 char(1),change column c2 c4 char(1); --正确
- --name关键字作为字段名,重命名需要加反引号(`)
- alter table table_name change `name` field_name varchar(50);
- alter table test change (c1 c3 char(1),c2 c4 char(1)); --错误
- --删除多列
- alter table test drop c1,drop c2; --正确
- alter table test drop column c1,drop column c2; --正确
- alter table test drop c1,c2; --错误
- alter table test drop (c1,c2); --错误
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement