MYSQL how to unlock table if I used command LOCK table table_name WRITE; -


this first question please bear me.

i have used command:

lock "table table_name write;"  

in mysql workbench lock new people adding rows table. cannot "unlock" table.
whenever try entering different commands example

select * table_name 

the screen keeps on loading. appreciated.

rules lock release


when table locks held session released, released @ same time. session can release locks explicitly, or locks may released implicitly under conditions.

  • a session can release locks explicitly unlock tables.

  • if session issues lock tables statement acquire lock while holding locks, existing locks released implicitly before new locks granted.

  • if session begins transaction (for example, start transaction), implicit unlock tables performed, causes existing locks released.

ref: http://dev.mysql.com/doc/refman/5.7/en/lock-tables.html


Comments