The LOCK TABLES privilege enables the use of explicit LOCK TABLES statements to lock tables for which you have the SELECT privilege. This includes the use of write locks, which prevents other sessions from reading the locked table

create database Susake;

use Susake;

create table Test(a int, b int);

lock tables Test read;

unlock tables;

insert into Test values(1, 2);

drop table Test;

drop database Susake;

【Mysql】lock tables,布布扣,bubuko.com

【Mysql】lock tables