delimiter ||
create TRIGGER t_after_insert_on_news_msg
after insert on news_msg
for each row
begin
insert into news_read (owner_id,`status`) values (new.owner_id, 1) on duplicate key update status = 1;
end ||
create TRIGGER t_after_insert_on_news_msg
after insert on news_msg
for each row
begin
insert into news_read (owner_id,`status`) values (new.owner_id, 1) on duplicate key update status = 1;
end ||
扫一扫
1601
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
