删除列:ALTER TABLE tb1_name DROP[COLUMN] col_name;
删除多列:ALTER TABLE tb1_name DROP[COLUMN] col_name1,DROP[COLUMN2] col_name2;
添加多列:ALTER TABLE tb1_name ADD[COLUMN] (col_name column_definition,...);
添加单列:ALTER TABLE tb!_name ADD[COLUMN] col_name column_definition [FIRST|AFTER col_name];
删除记录:DELETE FROM province WHERE id=3;
验证表中是否有相应的记录:SELECT * FROM province;
多次操作只要中间用‘,’连接即可。
如:
ALTER TABLE user ADD username VARCHAR(20) NOT NULL , DROP truename;
添加外键约束:ALTER TABLE users2 ADD FOREIGN KEY(pid)