Answers for "mysql lock table for update"

how to lock table in mysql

LOCK TABLE tablename WRITE;

Posted by: Guest on July-01-2021

how to find table lock and row lock in mysql

SHOW OPEN TABLES WHERE `Table` LIKE '%[TABLE_NAME]%' AND `Database` LIKE '[DBNAME]' AND In_use > 0;

Posted by: Guest on June-26-2021

Code answers related to "mysql lock table for update"