MySQL Database optimization

PHP has little technical content.

1: Select the appropriate field property, mostly set to NOT NULL

2. Using joins instead of subqueries

3. Save space by using union instead of manually creating temporary tables

4. Use things to handle complex logic.

5. Lock the table to prevent the database from repeating changes.

6. Use foreign keys to ensure data correlation.

7. Using the Index

8. Refine query statements

MySQL Database optimization