lock table a表后,怎么select b表也报错?

我建了2个表: iii1  ,  iii2

create table ccc1(id int,name char(30));  
create table ccc2(id int,name char(30));  

向iii1和iii2分别插入数据:
insert into  ccc1(id,name) values(1,'aa'),(2,'bb'),(3,'cc');
insert into  ccc2(id,name) values(1,'aa'),(2,'bb'),(3,'cc');

结果为:
mysql> select * from ccc1;
+------+------+
| id   | name |
+------+------+
|    1 | aa   |
|    2 | bb   |
|    3 | cc   |
+------+------+

mysql> select * from ccc2;
+------+------+
| id   | name |
+------+------+
|    1 | aa   |
|    2 | bb   |
|    3 | cc   |
+------+------+


然后我执行:
mysql> lock table ccc1 read;
Query OK, 0 rows affected (0.00 sec)
给表ccc1加了一个锁.


请问为什么我后面给表ccc2插入数据也报错.
mysql> insert into ccc2(id,name) values(4,'dd');
ERROR 1100 (HY000): Table 'ccc2' was not locked with LOCK TABLES

???

连select 也报错,这是什么逻辑?
mysql> select * from ccc2;
ERROR 1100 (HY000): Table 'ccc2' was not locked with LOCK TABLES

???