Paste this into a new question or an answer at dba.stackexchange.com:
<!-- --> > create table t(id integer); > > <pre> > ✓ > </pre> <!-- --> > begin; > > <pre> > ✓ > </pre> <!-- --> > insert into t(id) values(1); > > <pre> > ✓ > </pre> <!-- --> > rollback; > > <pre> > ✓ > </pre> <!-- --> > select * from t; > > <pre> > | id | > | :- | > </pre> *db<>fiddle [here](https://dbfiddle.uk/?rdbms=sqlite_3.8&fiddle=049a9f1746098ebabd02132f632fcb60)*
back to fiddle