|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
-- 新增
create
trigger
YQHL_HTJS_B_HTJBXX_INSERT before
insert
on
表名
for
each row
begin
if (NEW.F_SYNC_UPDATE
is
null
)
or
(NEW.F_SYNC_UPDATE = 0)
then
set
NEW.F_SYNC_UPDATE=
null
;
-- 把新增加的记录插入到操作记录表
insert
into
DATA_SYNC_B_OPERATOR(t_name, o_type, o_date, VKEYS)
values
(
'表名'
,1,
CURRENT_TIMESTAMP
,NEW.HTDQBH);
end
if;
end
;
-- 修改
create
trigger
YQHL_HTJS_B_HTJBXX_UPDATE before
update
on
表名
for
each row
begin
if (NEW.F_SYNC_UPDATE
is
null
)
or
(NEW.F_SYNC_UPDATE = 0)
then
-- 插入和更新操作，更新时间戳F_SYNC_DATE=systimestamp和F_SYNC_UPDATE=null
set
NEW.F_SYNC_UPDATE=
null
;
end
if;
end
;
-- 删除
create
trigger
YQHL_HTJS_B_HTJBXX_DELETE before
delete
on
表名
for
each row
begin
if (OLD.F_SYNC_UPDATE
is
null
)
or
(OLD.F_SYNC_UPDATE = 0)
then
-- 插入和更新操作，更新时间戳F_SYNC_DATE=systimestamp和F_SYNC_UPDATE=null
-- 把删除记录的主键添加到操作记录表
insert
into
DATA_SYNC_B_OPERATOR(t_name, o_type, o_date, VKEYS)
values
(
'表名'
,3,
CURRENT_TIMESTAMP
,OLD.HTDQBH);
end
if;
end
;
|
本文转自 乌英达姆 51CTO博客，原文链接:http://blog.51cto.com/7156680/1790835
