create database demo; use demo; CREATETABLE test ( tid INTNOTNULLprimary key, tname VARCHAR(50) NOTNULL ); INSERTINTO test VALUES(1,'version1'); INSERTINTO test VALUES(2,'version2');
image-20220715113204595
连接一
1 2 3 4
USE demo; START TRANSACTION WITH CONSISTENT SNAPSHOT; UPDATE test SET tname='version3'WHERE tid=2; SELECT*FROM test;
image-20220715113440161
可以看到连接一中数据已被修改。
连接二
1 2 3
USE demo; START TRANSACTION WITH CONSISTENT SNAPSHOT; SELECT*FROM test;