How to create and delete indexes in MySQL

This article mainly shares with you the methods of creating and deleting indexes in MySQL. I hope it can help you.

1. Add index

(1)ALTER TABLE statement

1.PRIMARY  KEY（主键索引）
        mysql>ALTER  TABLE  `table_name`  ADD  PRIMARY  KEY (  `column`  ) 
2.UNIQUE(唯一索引)
        mysql>ALTER  TABLE  `table_name`  ADD  UNIQUE (`column` ) 
3.INDEX(普通索引)
        mysql>ALTER  TABLE  `table_name`  ADD  INDEX index_name (  `column`  )
4.FULLTEXT(全文索引)
        mysql>ALTER  TABLE  `table_name`  ADD  FULLTEXT ( `column` )
5.多列索引
        mysql>ALTER  TABLE  `table_name`  ADD  INDEX index_name (  `column1`,  `column2`,  `column3`  )

(2)CREATE INDEX statement

1.UNIQUE(唯一索引)
        mysql>CREATE UNIQUE INDEX index_name ON `table_name` (`column` ) 
2.INDEX(普通索引)
        mysql>CREATE INDEX index_name ON `table_name` (  `column`  )
3.多列索引
        mysql>CREATE INDEX index_name ON `table_name` (  `column1`,  `column2`,  `column3`  )

2. Delete index

1.PRIMARY  KEY（主键索引）
        mysql>ALTER  TABLE  `table_name`  DROP PRIMARY KEY 
3.INDEX(普通索引)或UNIQUE(唯一索引)
        mysql>ALTER  TABLE  `table_name`  DROP INDEX index_name
        mysql>DROP INDEX index_name ON `talbe_name`

Related recommendations:

How to create an index for a join table related to two tables in MySQL Detailed graphic and text explanation

What is an index? How to create an index in MySQL

mysql index creation and index deletion

The above is the detailed content of How to create and delete indexes in MySQL. For more information, please follow other related articles on the PHP Chinese website!