# Create a transaction
# rollback transaction
# DDL statements are saved, DML statements are rolled back
# By default, Mysql is autocommit=ON 

select * from x;

--set autocommit = OFF;                 -- override option on SQL*Tester

start transaction;                      -- appears to not be necessary

drop table x;

create table x
(
    PK   int,
    data varchar(20)
) engine=innoDB;

insert into x values(1,'a');
insert into x values(2,'b');

update x set data='c' where PK=2;

select * from x;

rollback;

insert into x values(3,'A');

select * from x;