Transaction have the following four standard properties ,usually referred to by the acronym ACID.
* Atomicity-ensures that all operations within the work unit are completed successfully, otherwise the transaction is aborted at the point of failure and previous operations are rolled back to their former state.
*Consistency-ensures that the database properly changes states uon a successfully commited transaction.
*Isolation-enables transaction to operate independently of and transparent to to each other
*Durability-ensures that the result or effect of a committed transaction persists in case of a systemm failure
In Mysql, transactions begin with the statement BEGIN WORK and end with either a COMMIT or a ROLLBASCK statement.The SQL commands between the beginning and ending statements frorm the bulk of the transaction.