如何在 mysql 中创建作业或事件

本文介绍了如何在 mysql 中创建作业或事件的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我想在一天结束时运行的 mysql 中创建一个作业，在该作业中我想更新表中的一些列值.假设我有 2 个表，其中有一个名为 Status 的列，它是 Pending 或 Accepted.为此，我想创建一个工作，我想在其中搜索两个表并将 Pending 状态设置为 Accepted.

I would like to create a job in mysql which runs on the end of the day, where in that job I would like to update some of the column values in my tables. Assume I am having 2 tables where I am having a column named Status which is either Pending or Accepted. For this I would like to create a Job where I would like to search the two tables and set Pending status to Accepted.

有没有可能

推荐答案

使用 MySQL 的 事件调度程序:

Use MySQL's Event Scheduler:

DELIMITER ;; CREATE EVENT foo ON SCHEDULE EVERY DAY STARTS '2012-10-05 00:00:00' DO BEGIN UPDATE table1 SET Status = 'Accepted' WHERE Status = 'Pending'; UPDATE table2 SET Status = 'Accepted' WHERE Status = 'Pending'; END;; DELIMITER ;