触发器语句报错

来源：百度知道 编辑：UC知道 时间：2024/05/21 14:25:01
/*
Create Trigger 语句
出自 : MySQL 资料
*/
CREATE TRIGGER cdb_members_update_trigger after update
ON cdb_members FOR EACH ROW begin
declare @credits money
select @credits=credits from inserted
update coc_members set money = @credits
where coc_members.username = OLD.username
end ;

这是错误
错误代码: 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 '@credits money
select @credits=credits from inserted
update coc_members set mo' at line 7

好像是你的语句后面缺少;
CREATE TRIGGER cdb_members_update_trigger after update
ON cdb_members FOR EACH ROW begin
declare @credits money ;
select @credits=credits from inserted ;
update coc_members set money = @credits
where coc_members.username = OLD.username ;
end ;