Shulou(Shulou.com)05/31 Report--

This article introduces the knowledge of "the use of MYSQL event altimeter". Many people will encounter such a dilemma in the operation of actual cases, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

To see if the event Scheduler is currently open

SHOW VARIABLES LIKE 'event_scheduler'

Www.2cto.com

Turn on the event altimeter

SET GLOBAL event_scheduler = 1

Create an event

Syntax:

CREATE EVENT [IF NOT EXISTS] event_name

ON SCHEDULE schedule

[ON COMPLETION [NOT] PRESERVE]

[ENABLE | DISABLE]

[COMMENT 'comment']

DO sql_statement

Example:

CREATE EVENT updateInfoStatus

ON SCHEDULE EVERY 30 MINUTE

DO

UPDATE `jd_ status` SET `status` = 0 WHERE `status` = 1 AND `date`

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.