{"id":428,"date":"2023-09-14T16:11:00","date_gmt":"2023-09-14T08:11:00","guid":{"rendered":"https:\/\/www.keioi.cn\/?p=428"},"modified":"2023-09-14T16:11:01","modified_gmt":"2023-09-14T08:11:01","slug":"mysql%e5%ae%9a%e6%97%b6%e6%b8%85%e7%a9%ba%e8%a1%a8","status":"publish","type":"post","link":"https:\/\/www.keioi.cn\/archives\/428","title":{"rendered":"Mysql\u5b9a\u65f6\u6e05\u7a7a\u8868"},"content":{"rendered":"\n

1.\u8bbe\u7f6e\u5f00\u542fevent scheduler<\/p>\n\n\n\n

SET GLOBAL event_scheduler=1;<\/p>\n\n\n\n

2.\u9a8c\u8bc1event_scheduler\u662f\u5426\u5df2\u7ecf\u5f00\u542f<\/p>\n\n\n\n

show variables like ‘%event%’; #\u503c\u4e3a ON \u8868\u660e\u5df2\u5f00\u542f
SHOW VARIABLES LIKE ‘event_scheduler’;
3.\u521b\u5efaevent<\/p>\n\n\n\n

DROP EVENT IF EXISTS e_delete_upvote;
CREATE EVENT e_delete_upvote
ON SCHEDULE EVERY 1 day STARTS DATE_ADD(current_date(),INTERVAL 1 DAY) ON COMPLETION PRESERVE ENABLE
DO
TRUNCATE TABLE dreamland.upvote;<\/p>\n\n\n\n

\u8bf4\u660e\uff1a ON SCHEDULE EVERY 1 day \u6307\u5b9a\u5faa\u73af\u95f4\u9694\u4e3a\u6bcf\u5929\u6267\u884c<\/h1>\n\n\n\n

STARTS date_add(concat(current_date(), ‘ 23:59:00’), interval 0 second)
\u6307\u5b9a\u8fd0\u884c\u65f6\u95f4\u4e3a23:59:00 ON COMPLETION PRESERVE ENABLE \u6307\u5b9a\u521b\u5efa\u5b8c\u6210\u540e\u5373\u542f\u7528\uff0c\u5426\u5219\u9700\u624b\u52a8\u542f\u52a8<\/p>\n\n\n\n

4.\u624b\u52a8\u5173\u95ed\u4e8b\u4ef6<\/p>\n\n\n\n

ALTER EVENT e_delete_upvote DISABLE;<\/p>\n\n\n\n

5.\u624b\u52a8\u8be5\u4e8b\u4ef6\u4e3a\u53ef\u7528<\/p>\n\n\n\n

ALTER EVENT e_delete_upvote ENABLE;<\/p>\n\n\n\n

6.\u67e5\u770b\u5df2\u6709\u7684\u5b9a\u65f6\u4e8b\u4ef6\u4efb\u52a1<\/p>\n\n\n\n

SHOW EVENTS;<\/p>\n\n\n\n

7.\u5220\u9664\u4e8b\u4ef6<\/p>\n\n\n\n

DROP EVENT e_delete_upvote;<\/p>\n","protected":false},"excerpt":{"rendered":"

1.\u8bbe\u7f6e\u5f00\u542fevent sche...<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-428","post","type-post","status-publish","format-standard","hentry","category-4"],"_links":{"self":[{"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/posts\/428","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/comments?post=428"}],"version-history":[{"count":1,"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/posts\/428\/revisions"}],"predecessor-version":[{"id":429,"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/posts\/428\/revisions\/429"}],"wp:attachment":[{"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/media?parent=428"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/categories?post=428"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.keioi.cn\/api\/wp\/v2\/tags?post=428"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}