CODE EXAMPLE FOR SQL

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;