需求:
cdb_members表有两个字段:
credits和username coc_members表有两个字段:
money和username 我希望当cdb_members里的credits改变时,coc_members里具有相同username的money=credits我谈一下现在的状况,我用的是
MySQL client version: 5.0.27。
管理工具sqlyog 使用sqlyog产生的触发器模板是 DELIMITER $$; DROP TRIGGER `forum`.`coc_update`$$ CREATE TRIGGER `forum`.`coc_update` BEFORE/AFTER INSERT/UPDATE/DELETE on `forum`.`coc_members`
FOR EACH ROW BEGIN END$$ DELIMITER ;$$ 现在希望高人给条创建触发器的语句。触发器名称是coc_update
有的兄弟给了语句都是可以创建,但无法更新
这是语句
DELIMITER $$;create trigger `coc_update` AFTER UPDATE on `coc_members`
for each row BEGIN update cdb_members set credits = coc_members.money
where cdb_members.uid = coc_members.userid;
END;
$$DELIMITER ;$$------------------
DELIMITER $$;create trigger `coc_update` AFTER UPDATE on `coc_members`
for each row BEGIN declare f_credits decimal(10,2);
select credits from cdb_members into f_credits;
update coc_members set money = @credits where coc_members.userid = cdb_members.uid;
end; $$DELIMITER ;$$高人解。
cdb_members表有两个字段:
credits和username coc_members表有两个字段:
money和username 我希望当cdb_members里的credits改变时,coc_members里具有相同username的money=credits我谈一下现在的状况,我用的是
MySQL client version: 5.0.27。
管理工具sqlyog 使用sqlyog产生的触发器模板是 DELIMITER $$; DROP TRIGGER `forum`.`coc_update`$$ CREATE TRIGGER `forum`.`coc_update` BEFORE/AFTER INSERT/UPDATE/DELETE on `forum`.`coc_members`
FOR EACH ROW BEGIN END$$ DELIMITER ;$$ 现在希望高人给条创建触发器的语句。触发器名称是coc_update
有的兄弟给了语句都是可以创建,但无法更新
这是语句
DELIMITER $$;create trigger `coc_update` AFTER UPDATE on `coc_members`
for each row BEGIN update cdb_members set credits = coc_members.money
where cdb_members.uid = coc_members.userid;
END;
$$DELIMITER ;$$------------------
DELIMITER $$;create trigger `coc_update` AFTER UPDATE on `coc_members`
for each row BEGIN declare f_credits decimal(10,2);
select credits from cdb_members into f_credits;
update coc_members set money = @credits where coc_members.userid = cdb_members.uid;
end; $$DELIMITER ;$$高人解。
FOR EACH ROW
BEGIN
update coc_members set money = new.credits where username = old.username;
END$$DELIMITER ;$$
This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'可是我的版本是MySQL client version: 5.0.27。