Recently, I was doing a data transfer from one table to another in MySql through the Stored Procs. The size of the Source table is quite large, it has almost 50k+ rows. And my Stored Proc has a lot of JOIN statements. So to fetch what I need, it was taking a lot of time.
Now suddenly my internet went off due to some network issues. MySql showed me a Connection Error. When the connection came back I checked my Destination table , at that time it was empty as usual. But after few hours when I checked the Destination table, it was filled with my desired results. Let me tell you after the connection issue I did not run the Stored Proc again, but still it is filled.
So right now I'm a bit confused about what happened actually. Can anyone clarify it to me please?