MySQL Forums
Forum List  »  Triggers

SELECT-Statement in Trigger in IF
Posted by: Charlie
Date: October 29, 2005 05:14AM

Hi,

This code generates an error:

IF NEW_VALUE = '' THEN
SELECT column1 INTO NEW_VALUE FROM lkp_table where left(plz,4) = left(NEW.plz,4)) LIMIT 1;
END IF;

Isn't it allowed to use a select-statement in a trigger in a IF-Statement?

br
Charlie

Options: ReplyQuote


Subject
Views
Written By
Posted
SELECT-Statement in Trigger in IF
16329
October 29, 2005 05:14AM


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.