gabrieledarrigo · May 8, 2013 09:14
diff --git a/trigger_example.sql b/trigger_example.sql
 DELIMITER $$
  CREATE TRIGGER ai_photogallery AFTER INSERT ON photogallery_item
 	FOR EACH ROW
 	BEGIN
 		UPDATE photogallery_master
 		SET file = 
 		(SELECT file FROM photogallery_item WHERE id_photogallery = NEW.id_photogallery ORDER BY ordine DESC LIMIT 1)
 		WHERE id = NEW.id_photogallery;
 	END;
 $$
	DELIMITER $$
	CREATE TRIGGER ai_photogallery AFTER INSERT ON photogallery_item
	FOR EACH ROW
	BEGIN
	UPDATE photogallery_master
	SET file =
	(SELECT file FROM photogallery_item WHERE id_photogallery = NEW.id_photogallery ORDER BY ordine DESC LIMIT 1)
	WHERE id = NEW.id_photogallery;
	END;
	$$