操作

語法

示例

注意

修改表名

ALTER??TABLE?table_name?RENAME?TO?new_table_name

alter?table?testcjq?rename?to?testsuper;?

增加字段

ALTER?TABLE?table_name?ADD?field_name?field_type

alter?table?testsuper?add?aclomn?varchar(10)?default?null;

修改字段

ALTER?TABLE?table_name?MODIFY?field_name?field_type

alter?table?testsuper?modify?aclomn?varchar(20);

修改字段名稱及類型

ALTER?TABLE?table_name?CHANGE?old_field_name?new_field_name?field_type;?

alter?table?testsuper?change?aclomn?bclomn?int;?

修改一個字段的名稱，此時一定要重新指定該字段的類型?

刪除字段

ALTER?TABLE?table_name?DROP?field_name;

alter?table?testsuper?drop?bclomn;

添加主鍵索引

ALTER?TABLE?`table_name`?ADD?PRIMARY?KEY?(?`column`?)?

alter?table?testsuper?add?primary?key?(T_ID);

添加唯一索引

ALTER?TABLE?`table_name`?ADD?UNIQUE?(?`column`?)

alter?table?testsuper?add??UNIQUE?(T_IE);

alter?table?testsuper?add??UNIQUE?index?u1?(T_ID,TC_IE);//聯合唯一索引別名為u1的聯合索引

添加普通索引

ALTER?TABLE?`table_name`?ADD?INDEX?(?`column`?)?

alter?table?testsuper?add?index?(T_IF);

添加全文索引

ALTER?TABLE?`table_name`?ADD?FULLTEXT?(?`column`?)

alter?table?testsuper?add?fulltext?(T_IH);

添加聯合索引

ALTER?TABLE?`table_name`?ADD?INDEX?index_name?(?`column1`,?`column2`,?`column3`?)?

alter?table?testsuper?add?index?st?(T_IM,T_IN);