--source testconf.inc
USE test;
--disable_warnings
DROP TABLE IF EXISTS myCity;
--enable_warnings

SET autocommit = oFf;
CREATE TABLE myCity (a int, b char(20));
INSERT INTO myCity VALUES (1, 'Milan');
INSERT INTO myCity VALUES (2, 'London');
COMMIT;
DELETE FROM myCity; # implicit transaction started
SELECT COUNT(*) FROM myCity; # read transaction's modifications from master
COMMIT;

DROP TABLE myCity;