MySQL + SQL · Lesson 83
ACID Properties in DBMS and MySQL
What are ACID Properties?
ACID are four properties that guarantee reliable transactions. Every DBMS exam asks this.
The Four Properties
| Property | Meaning |
|---|---|
| Atomicity | All steps happen, or none do |
| Consistency | Database stays valid before and after |
| Isolation | Concurrent transactions do not interfere |
| Durability | Committed data survives crashes |
Example
In a bank transfer: Atomicity ensures both debit and credit happen together; Durability ensures that once committed, the transfer survives even a power failure.
Summary
- A = Atomicity, C = Consistency, I = Isolation, D = Durability.
- Together they make transactions reliable.
💻 Live Code Editor
Is page ki language (MYSQL) mein code likhein aur turant chalाएं — yahीं, bina kuch install kiye.Powered by OneCompiler. Agar editor na khule to yahान naye tab mein kholein.
💻 Live Code Editor
Is page ke program yahan ready hain — chalाएं, badlें aur seekhें. Bina kuch install kiye.
Powered by OneCompiler. Editor mein code apne aap aa jata hai — Run dabaakर output dekhें.
Agar load na ho to naye tab mein kholें.