如何回滚我在MySQL中的最后一个delete命令? [英] How can I roll back my last delete command in MySQL?

问题描述

我不小心从表中删除了很多行...

I accidentally deleted some huge number of rows from a table...

我该如何回滚?

我使用 PuTTY 执行了查询.

如果您能安全地指导我，我将不胜感激...

I'll be grateful if any of you can guide me safely out of this...

推荐答案

如果您尚未提交事务，请尝试rollback.如果已经提交事务(通过commit或退出命令行客户端)，则必须从上次备份中还原数据.

If you didn't commit the transaction yet, try rollback. If you have already committed the transaction (by commit or by exiting the command line client), you must restore the data from your last backup.

这篇关于如何回滚我在MySQL中的最后一个delete命令?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！