LUV7qX8t

1# connect command
2connect: mysql -ujohnlinp -psecret somedb
3
4# create table and populate data
5left: DROP TABLE IF EXISTS person;
6left: CREATE TABLE person (id INT NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL, age INT NOT NULL, PRIMARY KEY (id));
7left: INSERT INTO person (name, age) VALUES ('John Lin', 29);
8
9# start left transaction
10left: SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
11left: BEGIN;
12left: SELECT age FROM person WHERE id = 1;
13
14# start right transaction
15right: BEGIN;
16right: UPDATE person SET age = 30 WHERE id = 1;
17
18# continue left transaction
19left: SELECT age FROM person WHERE id = 1;
20
21# continue right transaction
22right: ROLLBACK; 
23     
24$ duosql demo.duo