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 vote160 views1 answer
How to define a non primary composite key in sql
SQL
0 vote197 views1 answer
How do you insert boolean to postgresql
SQL
0 vote140 views1 answer
Mysql query to add hours to column in table
SQL
0 vote133 views1 answer
Power query case when
SQL
1 vote150 views1 answer
Blob datatype in mysql
SQL
0 vote130 views1 answer
Alter table add foreign key mariadb example
SQL
0 vote233 views1 answer
Drop check command
SQL
0 vote130 views1 answer
Mysql use password error
SQL
0 vote184 views1 answer
Mysql select random rows large table
SQL
10 votes168 views6 answers
Mysql set root password
SQL