Re: TRIGGER BEFORE DELETE syntax error

[William Chiquito]

Hi Edi,

trigger:

DELIMITER $$

DROP TRIGGER `delete_personne`$$

CREATE TRIGGER `delete_personne` BEFORE DELETE on `personne`
FOR EACH ROW
BEGIN
	INSERT INTO histo_personne SELECT OLD.initialespers,OLD.nompers,OLD.prenompers,OLD.datenaisspers,OLD.photopers,OLD.validepers,now();
END$$

DELIMITER ;

works correctly.



Edited 1 time(s). Last edit at 02/22/2007 05:20AM by William Chiquito.