How to create and use indexes in Mysql?

Question

What else should you pay attention to when using it

Answer 1

Add the primary key field and set it to auto-increment. When adding data, if the primary key is null, the primary key will auto-increment

Answer 2

It is recommended that you read the MySQL manual, which has a detailed introduction to index creation http://www.php.cn/mysql/mysql-index.html