mysql数据库Event定时任务使⽤详解(Navicat及直接SQL语 激光除锈
⼀、使⽤Navicat创建Event
在上述存储过程中将⾃定义的sql语句填写到 BEGIN与END之间。 2、查看并打开event_scheduler调度事件:
再上图查询窗⼝执⾏查看:
聚四氟乙烯滑动支座
show variables like '%sche%';
注:如果event_scheduler值为OFF则使⽤set global event_scheduler =1;打开。
3、创建Event调度任务:
保存完毕,则在1中定义的存储过程scheduler_sync()将会被每隔10秒执⾏⼀次!
⼆、使⽤纯SQL语句创建定时任务Event。
1、进⼊到mysql ,并开启event_schduler:
set global event_scheduler =1;
show variables like '%event%';
2、进⼊wishstack创建存储过程(本次测试数据库为wishstack):
CREATE PROCEDURE sync_date_2_monitor()
BEGIN
/*-- 下述加⼊⾃定义的mysql处理逻辑 --*/
/*-- ----------------------------草率的爆破>耐高温盘根
-- 先删除 alert_msg 数据库表数据
-- 再同步 alert_msg 更新相关数据
-- ----------------------------*/
DELETE FROM monitor_screen.alarm_msg;
INSERT INTO monitor_screen.alarm_msg(id, alarm_id, resource_type, alarm_type, create
d_time, content, `level`)
SELECT UUID() AS id,
id AS alarm_id,
"2" AS resource_type,
CASE alarm_type
WHEN "state" THEN "状态告警"
END AS "alarm_type",
created_time,
description AS content,
CASE `level`
WHEN "general" THEN "1"
WHEN "serious" THEN "2"
WHEN "general" THEN "3"
END AS "level"
FROM alarm;
/*-- ----------------------------
-- 先删除 overall_statistic 数据库表数据
-- 再同步 overall_statistic 更新相关数据
-- ----------------------------*/
DELETE FROM monitor_screen.overall_statistic;