56,675
社区成员
发帖
与我相关
我的任务
分享
DELIMITER //
CREATE TRIGGER order_state_change AFTER UPDATE ON `ORDER`
FOR EACH ROW
BEGIN
IF( OLD.payment_amount >0 ) THEN
IF( OLD.state !=0 && NEW.state =0 ) THEN
UPDATE member SET shopping_points = shopping_points + OLD.payment_amount WHERE id = OLD.member_id;
END IF
END IF
END
//
DELIMITER ;
错误
SQL 查询:
CREATE TRIGGER `sq_actual`.`order_state_change` AFTER UPDATE ON `sq_actual`.`order` FOR EACH ROW BEGIN IF( OLD.payment_amount >0 ) THEN IF( OLD.state <>0 && NEW.state =0 ) THEN UPDATE member SET shopping_points = shopping_points + OLD.payment_amount WHERE id = OLD.member_id;
MySQL 返回:
#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 '' at line 5