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

2 votes143 views2 answers
Spring where to put the data sql
SQL
0 vote133 views1 answer
Mysql disable query caching
SQL
0 vote138 views1 answer
Sql select upcoming birthdays
SQL
16 votes154 views1 answer
Mysql smallint range
SQL
0 vote160 views1 answer
Get only structure database mysql
SQL
3 votes127 views1 answer
Oracle list user grants
SQL
0 vote135 views1 answer
Get week day name sql server
SQL
0 vote142 views1 answer
Sql #region
SQL
3 votes136 views1 answer
Show index table
SQL
0 vote138 views1 answer
Sql select column names starting with
SQL