mysql触发器

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 ||