Shulou(Shulou.com)06/01 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.