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
Post a Comment