MySQL read lock and write lock

Read Lock: All sessions can only be queried by the SELECT statement

TABLE [table_name] READ

SELECT * FROM table_name;

INSERT into table_name () VALUES ();   #一直等待, until unlocked or timed out

Write Lock: only the current session can be added and checked, other sessions cannot be any action

TABLE [table_name] WRITE

Unlock:

TABLES  #常规解锁  TABLE[table_name] READ   #再一次锁上, the last object that was intercepted was lifted. Then continue to intercept TABLE[table_name]WRITE  #再一次锁上, The last object that was intercepted was removed. And then continue to intercept .

MySQL read lock and write lock