1.数据表添加列
ALTER TABLE users1 ADD age TINYINT UNSIGNED NOT NULL DEFAULT 10;
2.添加列并位于某个列的后面
ALTER TABLE users1 ADD password VARCHAR(20) NOT NULL AFTER username;
3.删除一个列
ALTER TABLE users1 DROP password;
4.删除多个列
ALTER TABLE usres1 DROP age,DROP truename;
5.添加主键约束
ALTER TABLE users2 ADD CONSTRAINT PK_users2_id PRIMARY KEY(id)
6.添加唯一约束
ALTER TABLE users2 ADD UNIQUE(username);
7.添加外键约束
ALTER TABLE users2 ADD FOREIGN KEY (pid) REFERENCES provinces(id);
8.添加默认约束
ALTER TABLE users2 ALTER age SET DEFAULT 15;
9.删除默认约束;
ALTER TABLE users2 ALTER AGE DROP DEFAULT;