MariaDB/MySQL: Rollback not working in procedure

QuestionsMariaDB/MySQL: Rollback not working in procedure
sethbeckerman5 Staff asked 4 years ago

I am trying to create a procedure that contains a transaction that has a rollback:

However, when I am doing an insert on table that isn't possible due to unique constraints it's still deleting that record from . I would like to then rollback and undo the delete. What am I missing here?


View on Stack Overflow