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 ;