Closed DWoonD closed 6 years ago
Estou tentando importar e da esse erro
Comando SQL:
DROP TRIGGER IF EXISTS login_update;;
login_update
CREATE TRIGGER login_update BEFORE UPDATE ON login FOR EACH ROW BEGIN
login
IF OLD.sex <> 'S' AND MD5(OLD.user_pass) <> MD5(NEW.user_pass) THEN SET NEW.last_password_change = UNIX_TIMESTAMP(); END IF;
END;; Mensagens do MySQL : Documentação
CREATE TRIGGER login_update BEFORE UPDATE ON login FOR EACH ROW BEGIN ' at line 1
Estou tentando importar e da esse erro
Comando SQL:
DROP TRIGGER IF EXISTS
login_update;;CREATE TRIGGER
login_updateBEFORE UPDATE ONloginFOR EACH ROW BEGINIF OLD.sex <> 'S' AND MD5(OLD.user_pass) <> MD5(NEW.user_pass) THEN SET NEW.last_password_change = UNIX_TIMESTAMP(); END IF;
END;; Mensagens do MySQL : Documentação
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 ';
CREATE TRIGGER
login_updateBEFORE UPDATE ONloginFOR EACH ROW BEGIN ' at line 1