1数据库字段
添加
ALTER TABLE user2 ADD u_pass VARCHAR(20) NOT NULL AFTER u_name
更改
ALTER TABLE user2 MODIFY u_pass VARCHAR(10) NOT NULL
ALTER TABLE user3 CHANGE u_pass u_password VARCHAR(30) NOT NULL
删除
ALTER TABLE user2 DROP u_password
2约束
添加
ALTER TABLE user2 ADD CONSTRAINT ky_u_id PRIMARY KEY (id)
ALTER TABLE user2 ADD CONSTRAINT ky_u_name UNIQUE KEY (u_name)
ALTER TABLE user2 ADD CONSTRAINT ky_u_p_id FOREIGN KEY (pid) REFERENCES p(id)
删除
ALTER TABLE user2 DROP PRIMARY KEY
ALTER TABLE DROP user2 INDEX ky_u_name
ALTER TABLE DROP user2 FOREIGN KEY ky_u_p_id
3更改表名
ALTER TABLE user2 RENAME user1
RENAME TABLE user2 TO user1