cdb_members表有两个字段:
credits和username dede_members表有两个字段:
money和username 我希望当cdb_members里的credits改变时,dede_members里具有相同username的money=credits。 谢谢 money 里有默认字段,只是需要更新
credits和username dede_members表有两个字段:
money和username 我希望当cdb_members里的credits改变时,dede_members里具有相同username的money=credits。 谢谢 money 里有默认字段,只是需要更新
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_member`
FOR EACH ROW BEGINEND$$DELIMITER ;$$现在希望高人给条创建触发器的语句。触发器名称是coc_update
有的兄弟给了语句可是执行报错
这是语句
CREATE TRIGGER t_name BEFORE UPDATE ON cdb_members
FOR EACH ROW
BEGIN
IF OLD.credits <> NEW.credits THEN
UPDATE dede_members
SET money = NEW.credits
WHERE username = OLD.username ;
END IF;
END;
delimiter ; 高人解。
管理工具是SQLyog
用SQLyog产生的语句模板是
DELIMITER $$;DROP TRIGGER `forum`.`coc_update`$$CREATE TRIGGER `forum`.`coc_update` BEFORE/AFTER INSERT/UPDATE/DELETE on `forum`.`coc_member`
FOR EACH ROW BEGINEND$$DELIMITER ;$$有的兄弟给了我语句可是老是抱错,1064
CREATE TRIGGER t_name BEFORE UPDATE ON cdb_members
FOR EACH ROW
BEGIN
IF OLD.credits <> NEW.credits THEN
UPDATE dede_members
SET money = NEW.credits
WHERE username = OLD.username ;
END IF;
END;
delimiter ; 高人解
管理工具是SQLyog
用SQLyog产生的语句模板是
DELIMITER $$;DROP TRIGGER `forum`.`coc_update`$$CREATE TRIGGER `forum`.`coc_update` BEFORE/AFTER INSERT/UPDATE/DELETE on `forum`.`coc_member`
FOR EACH ROW BEGINEND$$DELIMITER ;$$有的兄弟给了我语句可是老是抱错,1064
CREATE TRIGGER t_name BEFORE UPDATE ON cdb_members
FOR EACH ROW
BEGIN
IF OLD.credits <> NEW.credits THEN
UPDATE dede_members
SET money = NEW.credits
WHERE username = OLD.username ;
END IF;
END;
delimiter ; 高人解
TRIGGER `forum`.`coc_update` AFTER UPDATE ON `forum`.`cdb_members`
FOR EACH ROW BEGIN
update coc_members set money = new.credits where username = old.username;
END;
$$DELIMITER ;