acid sql code example

Example 1: acid property db

A - Atomicity      transactions either take place or they dont. ('all or nothing' property)
C - Consistency	   Db must be consistent before and after a transaction.
I - Isolation      multiple transaction don't interfere with each other.
D - Durability     changes survive eventual failures of the system.

Example 2: acid properties

Atomicity 
Consistency
Isolation  
Durability