Re: Syntax Trigger in Mysql

[jororemy jor]

There is not really a mistake, it's just that when I execute the trigger from phpmyadmin, this is not an error, but it is cut at this level and the other party suddenly jumps

DROP TRIGGER IF EXISTS et_update_dru//
CREATE TRIGGER mdm_et_update_dru
AFTER UPDATE ON mdm_et_emp_pa
FOR EACH ROW
BEGIN
DECLARE uiduser,uidrole INT;
SELECT u.uid INTO uiduser
FROM user u
WHERE u.ref_id = NEW.ref_per and u.ref_a = NEW.ref_a;

IF uiduser IS NOT NULL THEN
UPDATE user
SET ref_id = NEW.ref_per, ref_a = NEW.ref_a, mail = NEW.mail, na = NEW.lo, pass = MD5(NEW.pa), sts = 1
WHERE ref_id = NEW.ref_per and ref_a = NEW.ref_a;
ELSE
INSERT INTO user (ref_id, ref_a, mail, na, pass, sts)
VALUES (NEW.ref_per, NEW.ref_a, NEW.mail, NEW.lo, MD5(NEW.pa), 1);

END IF;