Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Set isolation level (session) SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; -- Levels (weakest → strongest): -- READ UNCOMMITTED: sees dirty reads (uncommitted data) -- READ COMMITTED: no dirty reads; non-repeatable reads possible -- REPEATABLE READ: default; consistent snapshot within transaction -- SERIALIZABLE: locks all reads; slowest, safest SET GLOBAL TRANSACTION ISOLATION LEVEL REPEATABLE READ;
Result
Open