误更新:
select * from 表 as of timestamp sysdate - 前推分钟数/1440; #查看是否是误操作之前是数据
create table 新表 as (select * from 误操作表 as of timestamp sysdate - */1440); #将查询结果保存
update 表 t1
set t1.字段 =
(select 字段
from 表 AS OF TIMESTAMP SYSDATE – 3 / 1440
where t1.id = id)
对SQL的解释说明:
SYSDATE :当前时间
1440 :24h*60m=1440m
3:3分钟前
转载于:https://blog.51cto.com/aerwin/1878193