如何在MySQL中撤消? [英] How to do undo in Mysql?

问题描述

大家好

我已更改了表中列的所有行.

我需要这些价值观.我没有备份.

数据非常重要.

任何建议请.........

请帮我. :(

SwaxRak

Hi Everyone

I have changed all row in a column in a table.

I need the values. I don''t have back up.

The data is very very important.

Any suggestions please.........

Please help me. :(

SwaxRak

推荐答案

糟糕.

除非这是在事务内(并且您尚未提交)，否则以前的数据将永远消失.

抱歉-这就是为什么定期进行良好的备份如此重要的原因.

Oops.

Unless this is within a transaction (and you haven''t committed it) then your previous data is gone for good.

Sorry - but this is why good, regular, backups are so important.

只有可能的方式是使用DB事务日志...如果有mysql的日志.

Only possible way is using DB transaction logs ... if there is one for mysql.

如果您没有备份并且没有事务，那么您就没有数据.对不起.
这里的课程是始终备份您的数据.
切勿在生产环境中测试代码.然后，您始终可以将数据从生产向后迁移到开发环境中.
在学习的同时，立即形成良好的编程/系统维护惯例，以免在专业环境中这样做会浪费您的工作.

If you have no backup and you have no transaction then you have no data. Sorry.
The lesson here is to always back up your data.
Never test code in a production environment. Then you can always migrate the data backwards from production into your development environment.
Form good programming/system maintenance practices now while you are learning so that you don''t do this in a professional environment where it will cost you your job.

这篇关于如何在MySQL中撤消?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！