SHOW VARIABLES LIKE 'autocommit';SET autocommit = 0;
INSERT INTO `sugar`.`realmauctiondatum`(`Id`, `Name`) VALUES (3, 'A');
INSERT INTO `sugar`.`realmauctiondatum`(`Id`, `Name`) VALUES (1, 'A');
COMMIT;
如果没有调用COMMIT;退出session时会执行回滚
SHOW VARIABLES LIKE 'autocommit';SET autocommit = 0;
INSERT INTO `sugar`.`realmauctiondatum`(`Id`, `Name`) VALUES (3, 'A');
INSERT INTO `sugar`.`realmauctiondatum`(`Id`, `Name`) VALUES (1, 'A');
COMMIT;
如果没有调用COMMIT;退出session时会执行回滚