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

Editor to share with you what is the basic principle of mysql index, I hope you have something to gain after reading this article, let's discuss it together!

The principle of indexing is to convert unordered data into ordered queries.

1. Sort the contents of the index column.

2. The inverted table of production sorting results.

3. Spell the data address chain on the contents of the inverted table.

4. When querying for redemption, take out the inverted content first, and then take out the data address chain, so as to take out the specific data.

Example

CREATE TABLE articles (id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, title VARCHAR, body TEXT, FULLTEXT (title,body)) engine=myisam charset utf8 INSERT INTO articles (title,body) VALUES ('MySQL Tutorial','DBMS stands for DataBase...'), ('How To Use MySQL Well','After you went through a...'), ('Optimizing MySQL','In this tutorial we will show...'), ('1001 MySQL Tricks','1. Never run mysqld as root. 2.), ('MySQL vs. YourSQL','In the following database comparison...'), ('MySQL Security','When configured properly, MySQL...'); after reading this article, I believe you have a certain understanding of "what is the basic principle of mysql index". If you want to know more about it, welcome to follow the industry information channel, thank you for reading!

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.