2. 表锁

示例

表锁-MyISAM

create table tlock (a int(10) unsigned not null auto_increment,primary key(a)
                   )engine=myisam default charset=utf8;
insert into tlock(a) values(1),(2),(3);

session1:

session2:

session3: