MySQL取消索引值與改變欄位順序
1. 取消欄位索引標籤
drop index [field_name] on [table_name];
2. 列出索引鍵
show keys from [table_name];
3.改變欄位順序
alter table [table_name] modify [field_A] charvar(64) after [field_C];
#field_A 移到 field_C 後面
alter table [table_name] modify [field_A] charvar(64) first [field_D];
#field_A 移到 field_D 後面
drop index [field_name] on [table_name];
2. 列出索引鍵
show keys from [table_name];
3.改變欄位順序
alter table [table_name] modify [field_A] charvar(64) after [field_C];
#field_A 移到 field_C 後面
alter table [table_name] modify [field_A] charvar(64) first [field_D];
#field_A 移到 field_D 後面
