SQL Transactions ka Funda
Understand how SQL Transactions works with Fullstackgada
More Diagrams
Follow for More
🔄 SQL Transactions Explorer
Transactions: Sab kuch ek saath ya phir bilkul nahi! Stock ghatana, order daalna, payment — ya toh sab ho ya ek bhi nahi.
BEGIN
(Transaction shuru)
(Transaction shuru)
Stock -1
(Stock kam kiya)
(Stock kam kiya)
Order Added
(Order daala)
(Order daala)
Payment
(Payment hua)
(Payment hua)
Commit ya Rollback?
🏠 Gokuldham ka Analogy
Transaction = Shaadi ka Mandap!
🪔
Teen rasmein chal rahi hain: Haldi, Phere, Mangalsutra... Ek bhi chhuti toh shaadi cancel (Rollback)!
🎉
Sab rasmein poori? Commit – Shaadi pakki!
😨
Beech mein bijli chali gayi? – Rollback – Sab wapas, jaise kuch hua hi nahi.
💡 Transaction ke Properties (ACID)
A
Atomicity: Sab ya kuch bhi nahiC
Consistency: Data hamesha sahi rules peI
Isolation: Ek transaction doosre se alagD
Durability: Ek baar commit hua – data safe🔢 Example: Orders aur Stock Table
🛒 Orders Table
| OrderID | Product | Qty | Status |
|---|
📦 Stock Table
| Product | StockLeft |
|---|
💻 Transaction SQL ka Example
BEGIN;
/* Step 1: Stock kam karo */
UPDATE Stock SET count = count - 1 WHERE product='Soap';
/* Step 2: Order daalo */
INSERT INTO Orders(product, qty, status) VALUES ('Soap', 1, 'Pending');
/* Step 3: Payment */
-- Yahan payment step imagine karo
/* Sab theek hai */
COMMIT;
/* Agar koi ERROR */
ROLLBACK;
Sirf COMMIT ke baad data pakka! Error hua toh sab wapas (ROLLBACK).