Mysql 索引创建、删除及查看

添加索引

// PRIMARY  KEY（主键索引）ALTER  TABLE  `table_name`  ADD  PRIMARY  KEY (  `column`  ) //UNIQUE(唯一索引)ALTER  TABLE  `table_name`  ADD  UNIQUE (`column` ) //INDEX(普通索引)ALTER  TABLE  `table_name`  ADD  INDEX index_name (  `column`  )//FULLTEXT(全文索引)ALTER  TABLE  `table_name`  ADD  FULLTEXT ( `column` )//多列索引ALTER  TABLE  `table_name`  ADD  INDEX index_name (  `column1`,  `column2`,  `column3`  )

删除索引

可利用ALTER TABLE或DROP INDEX语句来删除索引。

DROP INDEX index_name ON talbe_nameALTER TABLE table_name DROP INDEX index_nameALTER TABLE table_name DROP PRIMARY KEY

查看索引

show index from tblname;show keys from tblname;