Hello,
I'm having some sintax problems using PL/SQL in mySQL TRIGGERS.. I need some help please :).
Here is the code:
CREATE TRIGGER modificou
AFTER UPDATE ON monitor
FOR EACH ROW
BEGIN
IF NOT EXISTS(SELECT estado_tmp FROM alteracoes WHERE id_tmp = OLD.id)
THEN
INSERT INTO alteracoes VALUES(OLD.id,NEW.estado);
ELSE
UPDATE alteracoes SET estado_tmp = NEW.estado WHERE id_tmp = OLD.id;
END IF;
END modificou;
What could be wrong?? For testing I'm using phpmyadmin 2.11.1
Thanks