mysql触发器多个条件_当条件为真时，如何使用MySQL触发器更新多个表？

最新推荐文章于 2024-08-04 21:25:05 发布

番禺狠人

最新推荐文章于 2024-08-04 21:25:05 发布

阅读量999

点赞数

文章标签： mysql触发器多个条件

本文链接：https://blog.csdn.net/weixin_31281027/article/details/113339881

版权

我试图创建一个触发器来更新另一个条件检查表，但我不断收到一个MySQL错误。我的触发器的代码是：

DELIMITER $$

CREATEb

TRIGGER visitor_validation

BEFORE INSERT ON ratingsvisitors

FOR EACH ROW

BEGIN

Set @counts=(SELECT count(*) from ratingsvisitors where visotrid=new.userid AND profileid=New.profileid AND itemid=New.itemid AND likevalidation=New.likevalidation AND likesordislike=New.likesordislike);

SET @ifexists = (SELECT * FROM ratingcounttracks WHERE userid=New.userid AND likedate=New.likevalidation AND countfor=New.likesordislike);

IF (@ifexists = NULL) THEN

INSERT INTO ratingsvisitors(userid, likedate, clickcount,countfor) values (New.userid, New.likevalidation ,'1',New.likesordislike);

ELSE

UPDATE ratingsvisitors SET clickcount=clickcount+1 WHERE userid=New.userid AND likedate=New.likevalidation AND countfor=New.likesordislike;

ENDIF;

END$$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 '; END' at line 12