mysql定时任务

1.创建存储过程
CREATE PROCEDURE insertorgAddress()
BEGIN
delete from org_address;
INSERT INTO org_address(orgid, orgname, address )
SELECT
orgid,
orgname,
concat(
(
SELECT
GROUP_CONCAT(o.orgname SEPARATOR ‘’)
FROM
sys_org_info o,
sys_org_child child
WHERE
o. STATUS = ‘1’
AND child. STATUS = ‘1’
AND o.ORGID = child.PAYWAYID
AND child.SUBWAYID = ld.orgid
ORDER BY
o.orglevel
),
'’,
(
SELECT
o.orgname
FROM
sys_org_info o
WHERE
STATUS = ‘1’
AND o.orgid = ld.orgid
)
) AS detailaddress
FROM
sys_org_info ld
WHERE
ld. STATUS = ‘1’
AND ld.orgtype = ‘grid’
AND ld.orgid LIKE concat(‘37’, ‘%’);
END;
2.定时器
create event if not exists insertorgAddress
on schedule every 24 HOUR
on completion preserve
do call insertorgAddress();