martes, 11 de mayo de 2010

MySQL: TRIGGERS

DELIMITER $$

CREATE
/*[DEFINER = { user | CURRENT_USER }]*/
TRIGGER `db_test`.`after_delete_person` AFTER DELETE
ON `db_test`.`person`
FOR EACH ROW BEGIN
DELETE FROM person_images WHERE id_user = OLD.idx;
END$$

DELIMITER ;

No hay comentarios:

Publicar un comentario