mysql update触发器
- DELIMITER $$
- CREATE
- /*[DEFINER = { user | CURRENT_USER }]*/
- TRIGGER `test`.`trig_update` AFTER UPDATE
- ON `test`.`shunqing_content_open`
- FOR EACH ROW
- BEGIN
- DECLARE num INT;
- IF(old.title<> new.title OR old.content<>new.content)
- THEN
- SELECT COUNT(0) INTO num FROM shunqing_content_tmp WHERE tid=new.tid;
- IF(num = 0)
- THEN
- INSERT INTO shunqing_content_tmp(tid,TYPE,createtime)VALUES(new.tid,2,NOW());
- END IF;
- END IF;
- END$$
- DELIMITER ;
============ 欢迎各位老板打赏~ ===========
与本文相关的文章
- · 定时备份docker中的mysql
- · docker-compose通过容器名连接mysql
- · unity3d mysql error: The given key was not present in the dictionary.
- · MySQL 批量修改数据表编码及字符集
- · Your database must use ‘READ-COMMITTED’ as the default isolation level.
- · MySQL-InnoDB存储引擎
- · 将数据从mysql迁移到clickhouse
- · mysql关于索引那些事儿
- · mysql大数据表加字段改名
- · mysql大数据表添加字段
- · MySQL 查看执行计划
- · asp.net zero改mysql