从 MYSQL 数据库检索已删除的行
我不小心删除了数据库的所有行，有没有办法将它们检索回来。由于我在部门服务器工作，因此我不会进行备份。但我知道在 oracle 中我可以回滚 DML 命令。我尝试使用回滚但它不起作用？
或者我必须再次创建整个数据库？
I have accidentally deleted all rows of the database is there a way to retrieve them back. Since I am working of department server I wont be take backup. But I know in oracle I could rollback the DML commands. I tried to use rollback but its not working?
or I have to create whole data base again?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
抱歉，但是如果带有删除语句的事务已经提交，那么我认为除非您有备份，否则您无法恢复丢失的数据。
为了避免这种事故，我建议在运行 DELETE 语句之前先使用 SELECT 查询测试 WHERE 子句。然后您会注意到它是否会删除您不打算删除的行。
Sorry, but if the transaction with the delete statement has already been committed then I don't think you can recover the lost data unless you have a backup.
To avoid this accident, I'd advise always testing your WHERE clause using a SELECT query first, before running a DELETE statement. Then you will notice if it will delete rows that you didn't intend to delete.