56,678
社区成员
发帖
与我相关
我的任务
分享
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