Mysql transaction commit and rollback instance

This section describes how to commit and roll back transactions in mysql.

The official syntax for creating a mysql stored procedure is:
Start transaction | BEGIN [WORK]

COMMIT [WORK] [AND [NO] CHAIN] [[NO] RELEASE]
ROLLBACK [WORK] [AND [NO] CHAIN] [[NO] RELEASE]
Set autocommit = {0 | 1}
Description: rollback of Multiple SQL statements processed by mysql transactions. For example, if you start a transaction in a stored procedure, this transaction inserts data into the three tables at the same time. After each inserted Table, You need to determine whether the operation is successful. If the operation is unsuccessful, You need to roll back, the last table determines whether it is successfully inserted and then commit. Note that you cannot directly use the collback of the transaction. In this way, rollback cannot be implemented or unexpected errors may occur.
A condition judgment is required, such as loop. because MySql will automatically submit by default, you do not have to worry about exit without commit after rollback.
Specific mysql statements:

Begin loop_lable: loop start transaction; insert into table1 (f_user_id) values (user_id); if row_count () <1 then set @ ret =-1; rollback; leave loop_label; end if; insert into table2 (f_user_id) values (user_id); if row_count () <1 then set @ ret =-1; rollback; leave loop_label; end if; insert into table3 (f_user_id) values (user_id); if row_count () <1 then set @ ret =-1; rollback; leave loop_label; else set @ ret = 0; commit; leave loop_label; end if; end loop; select @ ret; end