Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Transaction checklist: -- [x] Use InnoDB engine -- [x] Wrap related DML in START TRANSACTION ... COMMIT -- [x] Handle exceptions with ROLLBACK in application -- [x] Use REPEATABLE READ (default) or READ COMMITTED -- [x] Lock rows with FOR UPDATE when needed -- [x] Never call external APIs inside transactions -- [x] Monitor with INNODB_TRX and SHOW ENGINE INNODB STATUS
Result
Open