delimiter ||
DROP TRIGGER IF EXISTS t_afterinsert_on_evalua ||
CREATE TRIGGER t_afterinsert_on_a
AFTER INSERT ON a
FOR EACH ROW
BEGIN
insert into c(id, news_type, news_title) values(new.id,'new.type',new.title);
END||
delimiter ;
delimiter ||
DROP TRIGGER IF EXISTS trigger_after_insert ||
create trigger trigger_after_insert_b
after INSERT ON b
FOR EACH ROW
BEGIN
set @id=NEW.b_id;
set @news_content = new.content;
update c
set news_content = @news_content where id=@id;
END ||
delimiter ;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/31060020/viewspace-2152040/ ，如需转载，请注明出处，否则将追究法律责任。
