USE tpch1; DROP TABLE IF EXISTS MCOL_736; CREATE TABLE `MCOL_736` ( `code` varchar(255) NOT NULL ) ENGINE=InnoDB; INSERT INTO MCOL_736 (code) VALUES ('BR'); BEGIN; INSERT INTO MCOL_736 (code) VALUES ('UK'); SELECT 'INSIDE TRANSACTION' AS ''; INSIDE TRANSACTION ROLLBACK; SELECT * FROM MCOL_736; code BR DROP TABLE MCOL_736;