刪除

ALTER TABLE tb_name? DROP column_name;

添加

ALTER TABLE tb_name ADD column_name1 INT(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT "測試添加" AFTER?column_name2;

修改字段約束

ALTER TABLE tb_name MODIFY column_name CHAR(10);

改變字段，如名字

ALTER TABLE?tb_name?CHANGE column_name1 column_name2 INT(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT "字段改頭換面";

修改字段默認(rèn)值

ALTER TABLE tb_name ALTER column_name SET DEFAULT 1000;

修改表名

ALTER TABLE tb_name1 RENAME TO tb_name2;