MySQL Forums
Forum List  »  Triggers

syntax
Posted by: Marco Chan
Date: August 30, 2012 04:09AM

Hi
what wong's with this syntax?
It hightlight the last 2 lines not correct, I wonder if this is the ";" ...
Thanks

CREATE TRIGGER UPD_INTEGRAL_NO BEFORE INSERT ON mt4.mt4_trades
FOR EACH ROW
IF INSTR(BINARY new.comment,'O:') >0 THEN
SET NEW.INTEGRAL_OPEN = MID(new.comment,INSTR(BINARY new.comment,'O:')+2,8);
END IF;

Options: ReplyQuote


Subject
Views
Written By
Posted
syntax
1738
August 30, 2012 04:09AM
1240
August 31, 2012 06:08AM


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.