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

MySQL scheduled tasks and stored procedures are like, I believe that many inexperienced people do not know what to do, so this paper summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.

Shell scheduled tasks:

/ usr/bin/mysql-uroot-pxxxxx databasename-e "update table set."

Mysql event:

Check to see if event is enabled:

Mysql > show variables like'% sche%'

Event_scheduler | ON

Turn on the event plan: SET GLOBAL event_scheduler = 1

Turn off the event schedule: SET GLOBAL event_scheduler = 0

Close event task: ALTER EVENT eventName ON COMPLETION PRESERVE DISABLE

Open event task: ALTER EVENT eventName ON COMPLETION PRESERVE ENABLE

View event Task: SHOW EVENTS

DELIMITER / /

CREATE PROCEDURE yoon ()

BEGIN

Update a SET id = 2 WHERE id = 1

END / /

Create event if not exists e_yoon

On schedule every 10 second

On completion preserve

Do

Begin

Call yoon ()

End / /

The above event e_yoon indicates that yoon () is executed every 10 seconds.

After reading the above, have you mastered the method of MySQL scheduled tasks and stored procedures? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

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.