Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Test for MySQL "serializable" transaction, part 2
-- test for "serializable" -- first run session 1 (with sleep), see http://rextester.com/NBUU89499 -- while sleeping, run this. -- one should end up in a deadlock rollback; SET TRANSACTION ISOLATION LEVEL SERIALIZABLE; START TRANSACTION; SELECT * FROM person123_so_UUU WHERE name = 'Bob Ross'; INSERT INTO person123_so_UUU (name) VALUES ('Bob Ross'); SELECT last_insert_id(); COMMIT; SELECT * FROM person123_so_UUU;
run
|
edit
|
history
|
help
0
ruthresh
Select state by json
ITM_14210069
salamatova
1831
test
lab01
MySQL
Srinivas
chandu