query: # The HIGH_PRIORITY and FOR UPDATE seem to be necessary CREATE TABLE my_table AS SELECT HIGH_PRIORITY A . _field FROM _table AS A LEFT JOIN _table AS B USING (`pk`) LIMIT _digit FOR UPDATE; SELECT SLEEP(1); DROP TABLE my_table | LOCK TABLE _table READ , _table READ; SELECT SLEEP(1) UNLOCK TABLES; # LOCK TABLE _table READ , _table READ; # Locking two tables is needed