DROP TRIGGER IF EXISTS carrieres//
CREATE TRIGGER carrieres
BEFORE INSERT OR DELETE ON emplois
FOR EACH ROW
BEGIN
   IF INSERTING THEN
       UPDATE carrieres SET debauche = CURDATE() WHERE pID = NEW.pID AND debauche = '0000-00-00';
       INSERT INTO carrieres (pID, eID, fID, gID, salaire, embauche) VALUES (NEW.pID, NEW.eID, NEW.fID, NEW.gID, NEW.salaire, NOW());
   END IF;
   IF DELETING THEN
      UPDATE carrieres SET debauche = CURDATE() WHERE pID = OLD.pID AND debauche = '0000-00-00';
   END IF;
END//

Il semble qu'il y ait une erreur dans votre requête SQL. Le message ci-bas peut vous aider à en trouver la cause.

ERROR: Ponctuation invalide @ 33
STR: //
SQL: DROP TRIGGER IF EXISTS carrieres//# MySQL n'a retourné aucun enregistrement.

CREATE TRIGGER carrieres
BEFORE INSERT OR DELETE ON emplois
FOR EACH ROW
BEGIN
IF INSERTING THEN
UPDATE carrieres SET debauche = CURDATE() WHERE pID = NEW.pID AND debauche = '0000-00-00';
INSERT INTO carrieres (pID, eID, fID, gID, salaire, embauche) VALUES (NEW.pID, NEW.eID, NEW.fID, NEW.gID, NEW.salaire, NOW());
END IF;
IF DELETING THEN
UPDATE carrieres SET debauche = CURDATE() WHERE pID = OLD.pID AND debauche = '0000-00-00';
END IF;
END//
CREATE TRIGGER carrieres
BEFORE INSERT OR DELETE ON emplois
FOR EACH ROW
BEGIN
IF INSERTING THEN
UPDATE carrieres SET debauche = CURDATE() WHERE pID = NEW.pID AND debauche = '0000-00-00';
INSERT INTO carrieres (pID, eID, fID, gID, salaire, embauche) VALUES (NEW.pID, NEW.eID, NEW.fID, NEW.gID, NEW.salaire, NOW());
END IF;
IF DELETING THEN
UPDATE carrieres SET debauche = CURDATE() WHERE pID = OLD.pID AND debauche = '0000-00-00';
END IF;
END//


requête SQL:

CREATE TRIGGER carrieres BEFORE INSERT OR DELETE ON emplois FOR EACH ROW BEGIN IF INSERTING THEN UPDATE carrieres SET debauche = CURDATE() WHERE pID = NEW.pID AND debauche = '0000-00-00'; INSERT INTO carrieres (pID, eID, fID, gID, salaire, embauche) VALUES (NEW.pID, NEW.eID, NEW.fID, NEW.gID, NEW.salaire, NOW()); END IF; IF DELETING THEN UPDATE carrieres SET debauche = CURDATE() WHERE pID = OLD.pID AND debauche = '0000-00-00'; END IF; END//

MySQL a répondu:Documentation
#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 'OR DELETE ON emplois
FOR EACH ROW
BEGIN
IF INSERTING THEN
UPDATE c' at line 2