Transaction Create Function, Delimetter, Saveppoint, Roll back, Commit , My Sql Part 9

Transaction Create Function, Delimetter, Saveppoint, Roll back, Commit ,

https://www.youtube.com/channel/UC0Zkz85qlKt81MylcOiJSGg

Transaction Definition: A transaction is initiated using the START TRANSACTION or BEGIN command. This marks the beginning of a transaction and defines the boundary within which a set of database operations will be treated as a single unit.

Atomicity: Atomicity ensures that a transaction is treated as an indivisible unit of work. If any part of a transaction fails, the entire transaction is rolled back, and all changes made within the transaction are undone, returning the database to its previous state. The COMMIT command is used to commit a transaction, making all its changes permanent, while the ROLLBACK command is used to undo the changes and abort the transaction.

Isolation: Isolation refers to the concept of concurrent transactions appearing to execute in isolation from each other. MySQL supports different levels of isolation, such as READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE. These isolation levels define how locks are acquired and released, and to what extent one transaction can see the changes made by other concurrent transactions.

Consistency: Consistency ensures that a transaction brings the database from one valid state to another. The database constraints and integrity rules defined through schema definitions should be preserved during the execution of a transaction. If a transaction violates any constraints or integrity rules, it is rolled back, ensuring that the database remains in a consistent state.

Durability: Durability guarantees that once a transaction is committed, its changes are permanent and survive even in the event of system failure or power loss. MySQL ensures durability by writing transaction changes to disk or other non-volatile storage.

Savepoints: Savepoints allow you to define intermediate points within a transaction to which you can roll back. It enables you to create checkpoints within a transaction and selectively roll back to a specific savepoint without rolling back the entire transaction.