-- DROP EVENT IF EXISTS sync_mtrols_hourly;
CREATE
DEFINER=`test`@`localhost`
EVENT IF NOT EXISTS sync_mtrols_hourly
ON SCHEDULE EVERY 1 HOUR
ON COMPLETION NOT PRESERVE
COMMENT 'sync matter_info roleids to matter_exam each hour.'
DO
UPDATE matter_exam me
INNER JOIN
matter_info mi ON me.id = mi.id
SET
me.role_ids = mi.role_ids
WHERE
mi.role_ids IS NOT NULL;
调整
调整为每天执行一次
ALTER EVENT sync_mtrols_hourly ON SCHEDULE EVERY 1 DAY;