索引语法

1、创建索引

CREATE [ UNIQUE | FULLTEXT ] INDEX index_name ON table_name (col1,col2,col3...);

2、删除索引

DROP INDEX index_name ON table_name;

3、查看索引

SHOW INDEX FROM table_name;