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

92 阅读 0 评论 61 点赞

我是靠谱客的博主苹果电灯胆，最近开发中收集的这篇文章主要介绍mysql触发器多个条件_当条件为真时，如何使用MySQL触发器更新多个表？，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

我试图创建一个触发器来更新另一个条件检查表，但我不断收到一个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