Re: 1064 Error creating a trigger

[Dina Adballas]

hello,

I need to use a trigger in my program but I got a synthax error and I dont know what is wrong with my trigger, can you help me please? I am working with Mysql. thank you.

CREATE TRIGGER idmere_update AFTER UPDATE ON AJ_categorie
FOR EACH ROW
BEGIN
DECLARE idmere int;

select max(CATCODE) into @idmere
from AJ_categorie ;

update AJ_categorie set AJ__CATCODE=@idmere where CATCODE=@idmere;
END