查看索引
show index from tableName;
删除索引
alter table tableName drop index indexName;
drop index indexName on tableName;
添加索引
create table tableName(
id int
name varchar(20)
index indexName(columnName);
);
create index indexName on tableName(columnName)
alter table tableName
add index (columnName);