How does mysql build an index

Xiaobian to share with you how mysql index, I believe most people still do not know how, so share this article for your reference, I hope you read this article after a great harvest, let us go to understand it!

How to create MySQL index?

1. Add PRIMARY KEY

mysql>ALTER TABLE `table_name` ADD PRIMARY KEY ( `column` )

2. Add UNIQUE(Unique Index)

mysql>ALTER TABLE `table_name` ADD UNIQUE ( `column` )

3. Add INDEX

mysql>ALTER TABLE `table_name` ADD INDEX index_name ( `column` )

4. Add FULLTEXT(full-text indexing)

mysql>ALTER TABLE `table_name` ADD FULLTEXT ( `column`)

5. Add a multi-column index

mysql>ALTER TABLE `table_name` ADD INDEX index_name ( `column1`, `column2`, `column3` ) The above is all the contents of mysql how to build indexes. Thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!