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.
1 answers ( 0 marked as helpful)
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.
Submit an answer
Why did you not do not null, primary key and auto increment for customer id in the solution?