MySQL Table Locking

Using MySQL Table Locking you can lock a table explicitly for preventing other sessions for a interval. Releasing a table lock can be granted for a client session only but not for other sessions.

Here is a simple format for Table Locking:

LOCK TABLE tbl [READ | WRITE]

LOCK TABLE tbl READ

To release a lock from a table use below syntax:

UNLOCK TABLES;

Namaste UI

For any types of queries, you can contact us on info[at]namasteui.com.

You may like:  Reset auto increment values in MySQL