Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.

LOCK TABLES

The following command is not supported in MemSQL.

LOCK TABLES table_name [ READ | WRITE ] [, table_name [READ | WRITE]] ...

By default, it will emit this warning:

Feature 'LOCK TABLES' is not supported by MemSQL. Execution will continue, but the feature will be ignored.

The command has no effect. If you set the global engine variable warn_level to errors, then this command will return an error instead. The default behavior of returning a warning is for increased compatibility with some MySQL-compatible tools.