MySql 触发器

最新推荐文章于 2022-02-25 23:47:59 发布

iteye_17656

最新推荐文章于 2022-02-25 23:47:59 发布

阅读量88

点赞数

分类专栏： DataBase 文章标签： MySQL C C++ C#

DataBase 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

DELIMITER $$

DROP TRIGGER /*!50032 IF EXISTS */ `99aw`.`BrowseToIntegral`$$

CREATE
/*!50017 DEFINER = 'root'@'localhost' */
TRIGGER `BrowseToIntegral` AFTER INSERT ON `visit_me`
FOR EACH ROW BEGIN
DECLARE LogNum int DEFAULT 0;
DECLARE MyPoint int DEFAULT 0;
DECLARE BrowsNum int DEFAULT 0;
SELECT COUNT(*) INTO LogNum FROM visit_me where C_mid = NEW.C_mid and w_mid = NEW.w_mid;

/*防止恶意刷流量*/
IF LogNum <= 1 THEN
SELECT points INTO MyPoint FROM member WHERE mid = NEW.w_mid;
SELECT COUNT(*) INTO BrowsNum FROM (SELECT DISTINCT * FROM visit_me WHERE w_mid = NEW.w_mid GROUP BY C_mid ORDER BY C_mid) AS t;
/*每五百流量加1000积分*/
insert into testt(BrowsNum) values(BrowsNum);
IF BrowsNum > 0 AND BrowsNum % 500 = 0 THEN
SET MyPoint = MyPoint + 1000;
insert into testt(MyPoint) values(MyPoint);
UPDATE member SET points = 0 WHERE points IS NULL;
UPDATE member SET points = MyPoint WHERE mid = NEW.w_mid;
END IF;
END IF;

END;
$$

DELIMITER ;