Question

请问数据库 触发器 触发insert的语句怎么写啊

Answer 1

create trigger insert_data after insert on data_table FOR each row
begin
declare topic_id int;
select topic_uuid into topic_id from subtopic_table where subtopic_table.id=new.subtopic_uuid;
UPDATE sub_data_sum set datasum=datasum+1 where sub_data_sum.id=new.subtopic_uuid;
update data_sum set datasum=datasum+1 where data_sum.id=1;
update data_sum set datasum=datasum+1 where data_sum.id=topic_id;
end;
给你看一下我做的触发器吧，begin和end里面是你要做的处理，insert_data触发器名，after insert 意思就是在insert执行之后

Answer 2

CREATE TRIGGER 促发器名称 ON dbo.表名
FOR INSERT
AS

追问

有这么简单吗？

追答

具体你要达到什麽效果