56,914
社区成员




CREATE TABLE `t2` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(5) DEFAULT NULL,
`c` decimal(5,3) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=latin1;
CREATE DEFINER=`root`@`localhost` PROCEDURE `pp1`()
begin
DECLARE i varchar(200) ;
SET TRANSACTION ISOLATION LEVEL Serializable ;
start transaction ;
select name into i from t2 where id=3;
select * from t2 where id=3;
select sleep(10);
select * from t2 where id=3;
update t2 set name='pp1' where id=3;
select * from t2 where id=3;
commit ;
end;
CREATE DEFINER=`root`@`localhost` PROCEDURE `pp2`()
begin
SET TRANSACTION ISOLATION LEVEL Serializable ;
start transaction ;
/* select * from t2 where id=3 for update; */
select * from t2 where id=3 ;
insert into t2 (name ) values('test');
/*update t2 set name='pp2' where id=3 ;*/
select * from t2 where id=3 ;
commit;
end;
CREATE DEFINER=`root`@`localhost` PROCEDURE `pp1`()
begin
DECLARE i varchar(200) ;
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ ;
start transaction ;
select name into i from t2 where id=3;
select * from t2 where id=3;
select sleep(10);
select * from t2 where id=3;
update t2 set name='pp1' where id=3;
select * from t2 where id=3;
commit ;
end;
CREATE DEFINER=`root`@`localhost` PROCEDURE `pp2`()
begin
SET TRANSACTION ISOLATION LEVEL REPEATABLE READ ;
start transaction ;
/* select * from t2 where id=3 for update; */
select * from t2 where id=3 ;
/*insert into t2 (name ) values('test'); */
update t2 set name='pp2' where id=3 ;
select * from t2 where id=3 ;
commit;
end;