呵呵,简单列下就行啊 如:A表 ID INT 自增 FID varchar(16) 关联B表的 FID RESULT varchar(16) 需要更新到B 表的 RESULT 字段B表 FID INT 自增 RESULT varchar(16) 需要被A表同步更新的字段麻烦了,谢谢!~
自己搞定了...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
A插入记录,B是否也要同时插入,A、B两表有无关系?
简单一点如下即可。 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 update data_list set result=NEW.result where fid=NEW.fid;END
-- 详细说清楚!不然:人家没法下手帮你干活!
呵呵,简单列下就行啊 如:A表
ID INT 自增
FID varchar(16) 关联B表的 FID
RESULT varchar(16) 需要更新到B 表的 RESULT 字段B表
FID INT 自增
RESULT varchar(16) 需要被A表同步更新的字段麻烦了,谢谢!~
自己搞定了...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
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
update data_list set result=NEW.result where fid=NEW.fid;END