How to add mysql read-write lock?

How to add a mysql read-write lock: First log in to mysql and execute the command [show databases]; then execute show to see how many database tables there are, and add read locks to the ceshi table; finally add the Just write the lock.

How to add a read-write lock to mysql:

1. First, I log in to mysql through the command line and execute the commandshow databases; Check how many databases there are

2. Execute show to check how many database tables there are,select * from ceshiQuery the data in the table

3. Executelock table ceshi read; Add a read lock to the ceshi table.

#4. Table ceshi is also readable in another process, and writing will be delayed. After adding a read lock to the table, the read permission is available, but the write permission may be disabled or delayed.

5. Add a table write lock to the tablelock table ceshi write;

## 6. When a table is write-locked in a process, the process itself has both read and write permissions on the table, while other processes have neither read nor write permissions on the table.

Related learning recommendations:

mysql video tutorial

The above is the detailed content of How to add mysql read-write lock?. For more information, please follow other related articles on the PHP Chinese website!