I keep getting error when im creating trigger and i don't have idea how to fix it : CREATE TRIGGER ORDER_BILL_TRIG AFTER
INSERT ON ORDER_BILL
FOR EACH ROW MODE DB2SQL
[REFERENCING NEW AS N]
UPDATE ORDER_BILL
SET ORDER_BILL = QUANTITY * (SELECT FOOD_PRICE FROM FOOD WHERE
FOOD_PRICE = N.FOOD_NUM) WHERE N.FOOD_NUM = FOOD_NUM;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DB2SQL
[REFERENCING NEW AS N]
UPDATE ORDER_BILL
SET ORDER_BILL = QUANTITY * (SEL' at line 3