问一个mysql触发器的问题
来源:百度知道 编辑:UC知道 时间:2024/06/03 18:19:33
cdb_members表有两个字段:
credits和username
dede_members表有两个字段:
money和username
我希望当cdb_members里的credits改变时,dede_members里具有相同username的money=credits。
CREATE TRIGGER same
AFTER UPDATE
on cdb_members
FOR EACH ROW
begin
UPDATE dede_member SET money = NEW.credits
WHERE dede_member.username =NEW.username;
end
phpmyadmin下上述语句报错:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE dede_member SET money = NEW.credits
WHERE dede_member.userid =NEW.userna' at line 6
解决问题后可再加悬赏!!!
credits和username
dede_members表有两个字段:
money和username
我希望当cdb_members里的credits改变时,dede_members里具有相同username的money=credits。
CREATE TRIGGER same
AFTER UPDATE
on cdb_members
FOR EACH ROW
begin
UPDATE dede_member SET money = NEW.credits
WHERE dede_member.username =NEW.username;
end
phpmyadmin下上述语句报错:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE dede_member SET money = NEW.credits
WHERE dede_member.userid =NEW.userna' at line 6
解决问题后可再加悬赏!!!
create table cdb_members (
credits int,
username varchar(255)
)
create table dede_members (
money int,
username varchar(255)
)
create trigger cdb_members_update_trigger
after update
on cdb_members
for each row
begin
update dede_members set money = NEW.credits
where dede_members.username = OLD.username;
end;
上面的触发器在我的mysql上是可以的 你试试看