56,937
社区成员




create trigger trigger_after_insert
after INSERT
ON table_a FOR EACH ROW
update data_list set result=NEW.result where fid=NEW.fid;
create trigger trigger_after_insert
after INSERT
ON table_a FOR EACH ROW
BEGIN
set @fid=NEW.fid;
set @result=NEW.result;
update data_list set result=@result where fid=@fid;
END