官方文档
https://dev.mysql.com/doc/refman/8.0/en/commit.html

START TRANSACTION or BEGIN start a new transaction.

COMMIT commits the current transaction, making its changes permanent.

ROLLBACK rolls back the current transaction, canceling its changes.

SET autocommit disables or enables the default autocommit mode for the current session.

最简单的，就是
begin
insert …
insert …
…
commit;