mysql-触发器

mysql 触发器的实现

代码

-- Created by util.you.com@gmail.com-- 声明变量，用于存入 CXY_TS_ORDER_TICKET 表的 get_status 字段值,id 字段值-- 分别给 s1 和 s2 赋值delimiter $$CREATE TRIGGER `order_ticket_status_trigger` AFTER UPDATE ON `CXY_TS_ORDER_TICKET` FOR EACH ROW BEGIN     DECLARE s1 INT(11);     DECLARE s2 INT(11);     set s2 = new.id;     set s1 = new.get_status;    IF((old.get_status != new.get_status) OR (old.get_status IS NULL && new.get_status IS NOT NULL)) THEN        INSERT INTO `CXY_TS_ORDER_TICKET_STATUS`(`order_ticket_id`, `STATUS`, `insert_date_time`) VALUES(s2, s1, DATE_FORMAT(now(),'%Y-%m-%d %H:%i:%s'));    END IF; END$$