python - 数据库能不能撤消操作？不小心执行了一个update没有带where。。

Question

postgresql + navicat
想更新表a的某一行数据，结果忘加where条件了。
结果就是全部行都被update成了相同数据

这样还有救么？有撤销这次操作的方法吗？？

晕死了。。

Answer 1

The default log path is generally in /var/lib/pgsql/9.5/data/pg_log, and the default log level is ddl. Please find it quickly.

Answer 2

Learn your lesson.

The database prohibits destructive operations such as DELETE and UPDATE, and uses CREATE, INSERT, RENAME, version control, etc. instead.

Answer 3

Yes, pgsql should have the ability to write statement logs, just roll back. If mysql has it, pgsql should also have it

Answer 4

Unless you have a backup. .

Answer 5

Log recovery. Log recovery. Log recovery. Log recovery. Log recovery. Log recovery.