how to roolback delete command code example

Example 1: can we rollback data that are deleted using DELETE

yes, since this DELETE clause is from DML,
we can use ROLLBACK to recover the data.

Example 2: 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;