06
06/18
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,N...