cess a
non-locked table. If you try, the following error will be produced:

ERROR 1100 (HY000): Table 'tab_name' was not locked with LOCK TABLES

* While a connection holds an explicit lock on a table, it cannot issue the
following: INSERT DELAYED, CREATE TABLE, CREATE TABLE ... LIKE, and DDL
statements involving stored programs and views (except for triggers). If you
try, the following error will be produced:

ERROR 1192 (HY000): Can't execute the given command because you have active
locked tables or an active transaction

* LOCK TABLES can not be used in stored routines - if you try, the following
error will be produced on creation:

ERROR 1314 (0A000): LOCK is not allowed in stored procedures

URL: https://mariadb.com/kb/en/lock-tables/https://mariadb.com/kb/en/lock-tables/