MySQL Forums
Forum List  »  Triggers

ERROR: Unknown column in WHERE clause
Posted by: Lester Cutchall
Date: January 04, 2022 11:23AM

Here is the trigger for the Song_Entry table after insert:

UPDATE Contest
SET Songs_Entered =
(Songs_Entered + 1)
WHERE Contest.Contest_id =
Song_Entry.Contest_id;

I keep getting the above error message that says Song_Entry.Contest_id is unknown.

Options: ReplyQuote


Subject
Views
Written By
Posted
ERROR: Unknown column in WHERE clause
880
January 04, 2022 11:23AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.