MySQL Forums
Forum List  »  Triggers

IF / THAN in tiggers not working on 5.0.13-rc-nt-log ?
Posted by: Diqn Gochev
Date: October 22, 2005 05:31PM

Here is my queries:

CREATE TABLE account (acct_num INT, amount DECIMAL(10,2));
CREATE TRIGGER upd_check BEFORE UPDATE ON account
FOR EACH ROW
BEGIN
IF NEW.amount < 0 THEN
SET NEW.amount = 0;
END IF;
END;

This ot work on MySQL server 5.0.13-rc-nt-log. Can you help me ?

Options: ReplyQuote


Subject
Views
Written By
Posted
IF / THAN in tiggers not working on 5.0.13-rc-nt-log ?
2758
October 22, 2005 05:31PM


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.