两部分数量间隔如何在 EVENT 中工作? [英] How two-part-quantity intervals work in an EVENT?

问题描述

基于

好吧，我对单身没问题:YEAR、MONTH、DAY、SECOND、...

但我无法理解双工是如何工作的:YEAR_MONTH、DAY_HOUR、MINUTE_SECOND ...

<小时>

请看一下这个EVENT:

CREATE EVENT myevent每 5 秒按计划做/* 在这里查询 */

上面的

EVENT 将每 5 秒执行一次.这很清楚.但是如何关注 EVENT 呢?

CREATE EVENT myevent每 5 分钟一秒一班做/* 在这里查询 */

解决方案

MINUTE_SECOND => 'MINUTES:SECONDS'

http://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html

当您使用 MINUTES_SECONDS 时，您必须以上述格式提供

Based on the documentation, there is multiple kinds of interval quantity:

Ok I'm fine with single ones: YEAR, MONTH, DAY, SECOND, ...

But I cannot understand how duplex ones work: YEAR_MONTH, DAY_HOUR, MINUTE_SECOND ...

---

Please take a look at this EVENT:

CREATE EVENT myevent
    ON SCHEDULE EVERY 5 SECOND
    DO
/* query here */

EVENT above will be executed every 5 second. That's pretty clear. But how following EVENT works?

CREATE EVENT myevent
    ON SCHEDULE EVERY 5 MINUTE_SECOND
    DO
/* query here */

解决方案

MINUTE_SECOND => 'MINUTES:SECONDS'

http://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html

WHEN YOU USE MINUTES_SECONDS YOU HAVE TO GIVE IT IN ABOVE FORMAT

这篇关于两部分数量间隔如何在 EVENT 中工作?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！