The output shows zero rows returned when you Rollback?
When you rollback- it should show the number of rows but it always shows zero. Take a case when you deleted in the video without any condition and data got deleted in the departments_dup table. Now when you rollback- it should show the number of rows but it does not.
Thanks for reaching out.
Can you please clarify what you mean by "it always shows 0". Also, can you please support your question with screenshots to ensure that we are on the same page regarding the steps you are describing? This will help us assist you better.
Looking forward to your answer.
In the output, though the rollback worked (and reversed the changes), it shows "0 row(s) affected".