Created
July 11, 2019 03:32
-
-
Save ayuLiao/5fd31611452505429590f313ca4beb93 to your computer and use it in GitHub Desktop.
一次增加一个字段
一次增加多个字段
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # 增加一个字段 | |
| 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); --错误 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment