mysql大事务问题

-- 假设有一个大事务需要插入多条记录到两个表中
START TRANSACTION;

-- 插入记录到表A
INSERT INTO table_a (column1, column2) VALUES ('value1', 'value2');
INSERT INTO table_a (column1, column2) VALUES ('value3', 'value4');

-- 插入记录到表B
INSERT INTO table_b (column1, column2) VALUES ('value5', 'value6');
INSERT INTO table_b (column1, column2) VALUES ('value7', 'value8');

-- 提交事务
COMMIT;

-- 提交第一个小事务
START TRANSACTION;
INSERT INTO table_a (column1, column2) VALUES ('value1', 'value2');
INSERT INTO table_a (column1, column2) VALUES ('value3', 'value4');
COMMIT;

-- 提交第二个小事务
START TRANSACTION;
INSERT INTO table_b (column1, column2) VALUES ('value5', 'value6');
INSERT INTO table_b (column1, column2) VALUES ('value7', 'value8');
COMMIT;