1.查看索引
1.SHOW INDEX FROM index_test;
2.SHOW KEYS FROM index_test;
2.添加索引
1.添加主键索引
ALTER TABLE index_test ADD PRIMARY KEY (id);
2.添加唯一索引
ALTER TABLE index_test ADD UNIQUE (a);
3.添加普通索引
ALTER TABLE index_test ADD INDEX index_f (f);
4.添加联合索引
ALTER TABLE index_test ADD INDEX index_a_b_c (a, b, c);
5.添加全文索引
ALTER TABLE index_test ADD FULLTEXT (m);
3.删除索引
1.DROP INDEX a ON index_test;
2.ALTER TABLE index_test DROP INDEX index_f;