Berikut ini adalah jawaban pembetulan latihan trigger no 3 yaitu :

CREATE TRIGGER UPDATE_PLAYER2
AFTER UPDATE(LEAGUENO) ON PLAYERS FOR EACH ROW
BEGIN
CALL INSERT_CHANGE
(NEW.PLAYERNO, ‘U’, OLD.PLAYERNO);
END

Advertisements