fork download
copy 
  1.   INSERT INTO  CUSTOMER  (customerid,customername)   VALUES(1,'alpha') ;   
  2.     INSERT INTO CUSTOMER  (customerid,customername)  VALUES(2,'beta');     SAVEPOINT s1;
  3.     INSERT INTO CUSTOMER  (customerid,customername)  VALUES(3,'gamma');     SAVEPOINT s2;
  4.     INSERT INTO CUSTOMER  (customerid,customername)  VALUES(4,'tera');     SAVEPOINT s3;
  5.     INSERT INTO CUSTOMER  (customerid,customername)  VALUES(5,'omega');
  6.     ROLLBACK TO s3;
  7.     SELECT customername FROM CUSTOMER;
Success #stdin #stdout #stderr 0s 3448KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
stderr
copy 
Error: near line 1: no such table: CUSTOMER
Error: near line 2: no such table: CUSTOMER
Error: near line 3: no such table: CUSTOMER
Error: near line 4: no such table: CUSTOMER
Error: near line 5: no such table: CUSTOMER
Error: near line 6: no such savepoint: s3
Error: near line 7: no such table: CUSTOMER
https://ideone.com/fLOokp
language:
SQLite (sqlite 3.27.2)
created:
7 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!