MySQL的locktables和unlocktables的用法（转载）

mysql select * from user; ----------------- | id| name| ----------------- |22 | abc| |223 | dabc| | 2232 | dddabc| |45 | asdsagd| |23 | ddddddddd | ----------------- 5 rows in set (0.00 sec) mysql 自己的读操作未被阻塞

mysql> select * from user;

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

| id | name |

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

| 22 | abc |

| 223 | dabc |

| 2232 | dddabc |

| 45 | asdsagd |

| 23 | ddddddddd |

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

5 rows in set (0.00 sec)

mysql>

自己的读操作未被阻塞