当正在运行的 SQL 查询由于网络连接而中断时会发生什么
最近，我正在通过存储过程在 MySql 中将数据从一个表传输到另一个表。 源表的大小相当大，几乎有 50k+ 行。 我的存储过程有很多 JOIN 语句。因此，为了获取我需要的东西，我花了很多时间。
现在，由于一些网络问题，我的互联网突然中断了。 MySql 显示连接错误。当连接恢复时，我检查了我的目标表，当时它像往常一样是空的。 但几个小时后，当我检查目标表时，它填满了我想要的结果。让我告诉你，在连接问题之后，我没有再次运行存储过程，但它仍然被填满。
所以现在我对实际发生的事情有点困惑。有人可以向我澄清一下吗？
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?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论