Re: ERROR: Unknown column in WHERE clause
I made an error in my first reply, it should've been ...
UPDATE Contest
SET Songs_Entered = Songs_Entered + 1
WHERE Contest.Contest_id = NEW.Contest_id;
What you mistakenly call "crap" is the info I need re each table to help you with your Trigger.
Subject
Views
Written By
Posted
614
January 04, 2022 11:23AM
217
January 04, 2022 01:50PM
277
January 04, 2022 03:21PM
194
January 04, 2022 04:16PM
185
January 04, 2022 05:17PM
Re: ERROR: Unknown column in WHERE clause
216
January 04, 2022 09:44PM
174
January 04, 2022 11:09PM
177
January 05, 2022 12:00PM
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.