Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Bad: transaction holds locks while waiting for external API START TRANSACTION; UPDATE orders SET status = "processing" WHERE id = 101; -- ← Never call Stripe/email/third-party API here! COMMIT; -- Good: update inside transaction, call API outside START TRANSACTION; UPDATE orders SET status = "processing" WHERE id = 101; COMMIT; -- Then call API after commit callStripeAPI(101);
Result
Open