MySQL 强事务处理for update 死锁案例
CREATE TABLE `dbcache` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`skey` varchar(32) NOT NULL,
`value1` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB
注:默认隔离级别为“REPEATABLE-READ”
CREATE TABLE `dbcache` (`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`skey` varchar(32) NOT NULL,
`value1` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB
注:默认隔离级别为“REPEATABLE-READ”