说明
1、myisam表的读操作(添加读书锁)不会阻止其他过程对同一表的读操作，但会阻止同一表的写作操作。
2、只有读锁释放后，才能执行其他过程的写作操作。锁释放前不能取其他表。
实例
transaction-amysql> lock table myisam_lock read;query ok, 0 rows affected (0.00 sec) mysql> select * from myisam_lock;9 rows in set (0.00 sec) mysql> select * from innodb_lock;error 1100 (hy000): table 'innodb_lock' was not locked with lock tables mysql> update myisam_lock set v='1001' where k='1';error 1099 (hy000): table 'myisam_lock' was locked with a read lock and can't be updated mysql> unlock tables;query ok, 0 rows affected (0.00 sec)
以上就是mysql怎么共享读锁的详细内容。