Re: syntax

[Devart Team]

Try this code -

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

In this case the delimiters should be used, e.g. -

DELIMITER $$

CREATE TRIGGER
...
BEGIN
...
END$$

DELIMITER ;

Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/