Contoh CREATE TRIGGER MySQL

trigger1.sql

DELIMITER $$

CREATE TRIGGER grafik 
AFTER UPDATE ON plan
FOR EACH ROW 

BEGIN

	IF (EXISTS(SELECT `TGL_MULAI` FROM plan WHERE MONTH(`TGL_MULAI`)='05')) THEN

		UPDATE report 
		SET Berhasil = ( SELECT COUNT(*) AS Berhasil
			FROM plan
			WHERE Terlaksana = 'Berhasil' 
			AND MONTH( `TGL_MULAI` ) = '05' )
		, Gagal = ( SELECT COUNT(*) AS Gagal
			FROM plan
			WHERE Terlaksana != 'Berhasil'
			AND MONTH( `TGL_MULAI` ) = '05' ) 
		WHERE Bulan='MEI';

	ELSEIF (EXISTS(SELECT `TGL_MULAI` FROM plan WHERE MONTH(`TGL_MULAI`)='06')) THEN
	
		UPDATE report 
		SET Berhasil = ( SELECT COUNT(*) AS Berhasil
			FROM plan
			WHERE Terlaksana = 'Berhasil' 
			AND MONTH( `TGL_MULAI` ) = '06' ) 
		, Gagal = ( SELECT COUNT(*) AS Gagal
			FROM plan
			WHERE Terlaksana != 'Berhasil'
			AND MONTH( `TGL_MULAI` ) = '06' ) 
		WHERE Bulan='JUN';
			
	END IF;
END$$

DELIMITER ;