事务
「已注销」
每天都在快乐地搬砖
展开
-
MySql事务隔离级别-未提交读(READ UNCOMMITTED)
准备工作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...原创 2019-08-04 01:06:39 · 1054 阅读 · 0 评论 -
MySql事务隔离级别-已提交读(READ COMMITTED)
准备工作以及SQL解释参考:https://mp.csdn.net/postedit/98398695执行步骤 SESSION A SESSION B T1 SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; T2 START TRANSACTION; T3 ...原创 2019-08-04 11:27:35 · 965 阅读 · 0 评论 -
MySql事务隔离级别-可重复读(REPEATABLE READ)
准备工作以及SQL解释参考:https://mp.csdn.net/postedit/98398695执行步骤 SESSION A SESSION B T1 SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ; T2 START TRANSACTION; T3 ...原创 2019-08-04 11:38:58 · 340 阅读 · 0 评论 -
MySql事务隔离级别-序列化(SERIALIZABLE)
准备工作以及SQL解释参考:https://mp.csdn.net/postedit/98398695INSERT INTO `t1` VALUES (1, 100);执行步骤 SESSION A SESSION B T1 SET SESSION TRANSACTION ISOLATION LEVELSERIALIZABLE; T2 ST...原创 2019-08-04 12:15:17 · 482 阅读 · 0 评论