SQL

CREATE TRIGGER tg_tournaments_teams_st_goals BEFORE INSERT ON match_dataFOR EACH ROWBEGIN   DECLARE teamIdofplayer INTEGER;   DECLARE teamIdAwayMatch INTEGER;   DECLARE teamIdHomeMatch INTEGER;   DECLARE tournamentId INTEGER;   CASE NEW.data_type WHEN 'goal'THEN   SELECT team_id INTO teamIdofplayer FROM players WHERE id = NEW.player_id;  END CASE;END//