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
原文：http://www.cnblogs.com/Cxx-Code/p/3632047.html