trigger_IF

create trigger grafik AFTER UPDATE on plan
for each row begin
if 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' ) where Bulan='MEI'

update report set Gagal = (SELECT count( * ) AS Gagal
FROM plan
WHERE Terlaksana != 'Berhasil'
AND month( `TGL_MULAI` ) = '05' ) where Bulan='MEI'
ELSEIF 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' ) where Bulan='Jun'

update report set Gagal = (SELECT count( * ) AS Gagal
FROM plan
WHERE Terlaksana != 'Berhasil'
AND month( `TGL_MULAI` ) = '06' ) where Bulan='JUN'
END IF
END$$