Скачать или смотреть How to create a transaction using a stored procedure in MySQL.

You can use the START TRANSACTION, COMMIT, and ROLLBACK statements in the procedure's body to start a transaction using a stored procedure in MySQL. A transaction assures that a series of SQL statements are handled as a single unit of work and that, in the event of an error or certain condition, either all the changes are implemented (committed) or none of them are rolled back.
One or more SQL statements that must be performed as part of the transaction can be included inside the transaction. We have an INSERT or a UPDATE statement in this example.
In situations when several processes must be carried out as one, maintaining data consistency and integrity, MySQL transactions have a number of benefits. The following are some benefits of utilizing transactions in MySQL:
ATOMICITY
CONSISTENCY
ISOLATION
CONCURRENCY CONTROL
DATA INTEGRITY
DATE RECOVERY
TESTING AND DEBUGGING
COMPLEX OPERATION
ERROR HANDLING
MySQL transactions are essential for preserving data consistency, concurrency, and integrity in database systems. They offer a strong method for managing complicated activities and guaranteeing that data is kept in a consistent and trustworthy form.