Mysql undo delete

start transaction;

savepoint sp1;

delete from customer where ID=1;

savepoint sp2;

delete from customer where ID=2;

rollback to sp2;

rollback to sp1;

Source: stackoverflow.com

Similar codes

0 vote385 views1 answer
Mysql case when on date
SQL
2 votes368 views1 answer
How to find constraints on a table in oracle
SQL
2 votes383 views1 answer
Sql string_agg
SQL
0 vote356 views1 answer
Query archive mode
SQL
0 vote335 views1 answer
Pl sql turn off variable substitution
SQL
0 vote353 views1 answer
Online sql testing tool
SQL
0 vote392 views1 answer
How to find the most occuring in SQL
SQL
0 vote344 views1 answer
Acual month sql
SQL
11 votes362 views1 answer
Oracle insert into where
SQL
0 vote356 views1 answer
Sp in sql server
SQL