分享一个MySQL表lock的例子

lock锁

简单锁例子,对tester表加读锁定

mysql> lock table tester read;
Query OK, 0 rows affected (0.00 sec)

mysql> desc tester;
+-------+-------------+------+-----+---------+----------------+
| Field | Type        | Null | Key | Default | Extra          |
+-------+-------------+------+-----+---------+----------------+
| id    | int(10)     | NO   | PRI | NULL    | auto_increment |
| name  | varchar(20) | YES  |     | NULL    |                |
| age   | int(10)     | YES  |     | NULL    |                |
| email | varchar(20) | YES  | UNI | NULL    |                |
+-------+-------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

mysql> insert into tester (name,age,email) values ('fei',34,'678@qq.com');
ERROR 1099 (HY000): Table 'tester' was locked with a READ lock and can't be updated

释放锁例子

mysql> unlock table;
Query OK, 0 rows affected (0.00 sec)

mysql> insert into tester (name,age,email) values ('fei',34,'678@qq.com');
Query OK, 1 row affected (0.01 sec)