- 带注释
ALTER TABLE user ADD nickname varchar(25) COMMENT ‘昵称’;
- 带注释和默认值
ALTER TABLE user ADD age int DEFAULT 20 COMMENT ‘年龄’;
- 为已有字段添加默认值
ALTER TABLE user ALTER COLUMN nickname SET DEFAULT ‘刘德华’;
- 修改字段名
ALTER TABLE user ALTER COLUMN id uid varchar(32);