MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table DEMO (n int);
begin transaction;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'transaction' at line 1

insert into DEMO values (0);
select n "after insert" from DEMO;

after insert

0

update DEMO set n=1/n;
Division by 0

select n "after error" from DEMO;

after error

0

commit;
select n "after commit" from DEMO;

after commit

0