这个mysql的触发器错哪了？

[LGP88864237]

DELIMITER |
CREATE TRIGGER trg_CheckApplyStock BEFORE UPDATE ON t_ApplyStock
FOR EACH ROW BEGIN
IF UPDATE(F_Check) THEN

IF EXISTS(SELECT top 1 * FROM t_StockOrderDetail a,inserted b WHERE a.F_LinkBill = b.F_BillID) THEN

ROLLBACK TRANSACTION

raiserror('本单已被采购订单引用，不能反审！！',18,18)
END IF;
END IF;
END
|
DELIMITER ;



报的错误


错误码: 1064
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 'UPDATE(F_Check) THEN

IF EXISTS(SELECT top 1 * FROM t_StockOrderDetai' at line 3

Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000

[hai2003xp]

既然是update触发器，为什么还用if update()语句

[GOODlivelife]

mysql触发器没有inserted和deleted，只有NEW和OLD，而且它们不是表

[GOODlivelife]

参考用户手册
http://dev.mysql.com/doc/refman/5.1/zh/index.html

[dawugui]

mysql?
帮顶.