MySQL Transaction Example with COMMIT and ROLLBACK

A Complete Transaction

The Code

START TRANSACTION;

UPDATE accounts SET balance = balance - 1000 WHERE id = 1;
UPDATE accounts SET balance = balance + 1000 WHERE id = 2;

-- if both succeeded:
COMMIT;
-- if something failed, instead run:
-- ROLLBACK;

Summary

• Wrap related updates in START TRANSACTION ... COMMIT.
• ROLLBACK undoes everything if any step fails.

एक पूरा Transaction

Code

START TRANSACTION;

UPDATE accounts SET balance = balance - 1000 WHERE id = 1;
UPDATE accounts SET balance = balance + 1000 WHERE id = 2;

-- दोनों सफल हुए तो:
COMMIT;
-- कुछ fail हुआ तो बजाय इसके:
-- ROLLBACK;

सारांश

• Related updates को START TRANSACTION ... COMMIT में लपेटें।
• कोई step fail हो तो ROLLBACK सब undo कर देता है।