如何在mysql中设置一个计时器 [英] How to set a timer in mysql

问题描述

假设当前日期是20141110 10:00 pm，
我想让mysql更新一个字段，然后将几个字段转储到一个文件中，而日期是20141201 10:00 pm

Suppose the current date is 20141110 10:00pm , I would like to let mysql to update a field and then dump few fields into a file while the date is 20141201 10:00pm

如何实现？

我知道的是使用事件，但这似乎是在一些间隔时间内使用的。像每几个小时/天/周一样使事件发生。

What I know is to use event, but this seems to be used under some interval time. like every few hours/days/weeks to make the event happen.

推荐答案

Mysql事件是好的选项，或者可以使用数据库触发器如果你有较旧版本的mysql。

Mysql events is good option or you can use database triggers if you have older version of mysql.

http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html
http://www.mysqltutorial.org/mysql-triggers/working-mysql-scheduled-event/

这篇关于如何在mysql中设置一个计时器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！