Answers for "mysql rollback last delete"

SQL
4

mysql delete last row

DELETE FROM my_table WHERE my_col_id = (SELECT MAX(my_col_id) FROM my_table);
Posted by: Guest on June-20-2021
0

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;
Posted by: Guest on June-01-2020

Code answers related to "mysql rollback last delete"

Code answers related to "SQL"

Browse Popular Code Answers by Language