读锁案例分析
建表及准备数据:
CREATE TABLE mylock(
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(20)
)ENGINE MYISAM;
INSERT INTO mylock(name) VALUES('a');
INSERT INTO mylock(name) VALUES('b');
INSERT INTO mylock(name) VALUES('c');
INSERT INTO mylock(name) VALUES('d');
INSERT INTO mylock(name) VALUES('e');
select * from mylock;
#手动增加表锁
lock table 表名 read(write), 表名2 read(write), 其他;
#查看表上加过的锁
show open tables;