Answers for "mysql lock table"

SQL
1

how to lock table in mysql

LOCK TABLE tablename WRITE;
Posted by: Guest on July-01-2021
0

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 "SQL"

Browse Popular Code Answers by Language