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.
Hi Abdul!
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.
Kind regards,
Martin
In the output, though the rollback worked (and reversed the changes), it shows "0 row(s) affected".
Hi Tetiana!
Thanks for reaching out.
This is MySQL's way to say that this command has not changed the state of the initial database.
Hope this helps.
Best,
Martin