Locking is an important concept in databases. They help regulate access to the data, so your SELECT queries return consistent results and DML and DDL statements leave the data and schema in a consistent state. For the data, there are …

Locking SELECT with CREATE TABLE, INSERT INTO, and User Variables Read more »