瀚高数据库
data目录下修改
#track_commit_timestamp =off 为
track_commit_timestamp =on
#hg_fbq_retention=0 修改为
hg_fbq_retention=
6000s
建议此处时间设置长点
#hg_fbq_guarantee=off
修改为
hg_fbq_guarantee=off
然后重启数据库
create
table
feedback_test (id
int
,
name
varchar
(
20
))
;
insert
into
feedback_test
values
(
1
,
'wang'
),(
2
,
'qing'
)
;
delete
from
feedback_test
where
id =
2
;
select
*
from
feedback_test
；
select
*
from
feedback_test flashback
between
timestamp
'2020-06-02 17:03:01'
and
'2020-06-02 17:03:59'
where
id =
2
;
insert
into
feedback_test
select
*
from
feedback_test flashback
between
timestamp
'2020-06-02 17:03:01'
and
'2020-06-02 17:03:59'
where
id =
2
;
select
*
from
feedback_test
；
