准备工作
DROP TABLE IF EXISTS `t1`;
CREATE TABLE `t1` (
`id` int(11) NOT NULL,
`num` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
执行步骤
SESSION A | SESSION B | |
T1 | SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED; | |
T2 | START TRANSACTION; | |
T3 | SET SESSION TRANSACTION ISOLATION LEVE |