mysql 事件(定时任务)

DELIMITER $$


ALTER DEFINER=`dbmanager`@`%` EVENT `book_info 定时更新` ON SCHEDULE EVERY 1 DAY STARTS '2017-10-16 23:00:00' ON COMPLETION PRESERVE ENABLE DO BEGIN


DELETE FROM guidancelearn.`book_info`;
INSERT INTO guidancelearn.`book_info` (bookId,NAME,gradename,grade,SUBJECT,subjectname,edition,editionname,press,section,province) 
SELECT a.id, a.name,c.bookstore_name, c.bookstore_id, a.subject, d.subject_name, a.edition, b.edition_name, e.name, f.section_name, g.name
FROM lftquestdb.bookmark a 
LEFT JOIN lftquestdb.edition_info b ON a.edition = b.edition_key 
LEFT JOIN lftquestdb.bookmark_store_grade c ON a.grade = c.id
LEFT JOIN lftquestdb.subject_info d ON a.subject = d.id 
LEFT JOIN lfteditsystem.`press_info` e ON a.press_id = e.id
LEFT JOIN lftquestdb.`section_info` f ON a.section = f.id
LEFT JOIN lfteditsystem.`province` g ON a.paper_province = g.code
WHERE a.listing BETWEEN '2017-07-15' AND '2018-02-29' AND a.type >10 AND STATUS =1;


	END$$


DELIMITER ;