当前进程不能进行插入和更新操作

mysql> insert into first_test(age) values(15);

ERROR 1099 (HY000): Table 'first_test' was locked

with a READ lock and can't be updated

?

mysql> update first_test set age=200 where id =1;

ERROR 1099 (HY000): Table 'first_test' was locked

with a READ lock and can't be updated

其他进程可以进行插入，但是更新会等待：

mysql> insert into first_test(age) values(15);

Query OK, 1 row affected (0.00 sec)

?

mysql> update first_test set age=200 where id =2;

等待.....

当前进程不能不能访问其他进程插入的数据

?

mysql> select * from first_test;

+----+------+

| id | age |

+----+------+

| 1 | 100 |

| 2 | 11 |

| 3 | 12 |

| 4 | 13 |

| 5 | 14 |

| 6 | 14 |

+----+------+

6 rows in set (0.00 sec)

释放锁以后皆大欢喜

mysql> unlock table;

Query OK, 0 rows affected (0.00 sec)

插入的和更新的都出来的：

?

mysql> select * from first_test;

+----+------+

| id | age |

+----+------+

| 1 | 100 |

| 2 | 200 |

| 3 | 12 |

| 4 | 13 |

| 5 | 14 |

| 6 | 14 |

| 7 | 15 |

+----+------+

7 rows in set (0.00 sec)

mysql> update first_test set age=200 where id =2;

Query OK, 1 row affected (1 min 39.75 sec)

Rows matched: 1 Changed: 1 Warnings: 0