####入侵事件触发器
DELIMITER //
CREATE TRIGGER 触发器名称
AFTER INSERT ON 表名 FOR EACH ROW
BEGIN
DECLARE place_area_id_new VARCHAR(64);
SELECT place_area_id INTO place_area_id_new FROM `cvp_camera` WHERE `device_id` = new.device_id AND `edge_no` = new.channel_num;
INSERT INTO `dic_all_events`(`alertor_type`, `analysis_ts`,
`device_id`, `channel_num`, `place_area_id`,
`photo_path`, `create_date`, `create_time`, `tsdate`)
VALUES
(new.`alertor_type`, new.`analysis_ts`,
new.`device_id`, new.`channel_num`, place_area_id_new,
new.`photo_path`, new.`create_date`, new.`create_time`,
new.`tsdate`);
END //
DELIMITER ;
MySQL触发器查询其他表数据作为结果
于 2024-09-11 16:29:42 首次发布