Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
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
Please
log in
to post a comment.
Conditional SQL select
tooo
Top 2 Query
sunil
My mysql code - sunil
GROUP_CONCAT Mysql
ventas
1
test
join tables multiple columns
Please log in to post a comment.