玛丽亚数据库中的活动时间表 [英] event schedules in maria db

问题描述

以下查询失败:

CREATE EVENT `UNUSED` 
ON SCHEDULE EVERY 1 HOUR 
STARTS '2016-06-14 11:00:00.000000' ENDS '2016-06-30 01:00:00.000000' 
ON COMPLETION NOT PRESERVE ENABLE DO 
UPDATE quotation_details SET status='UNUSED' WHERE updatedTime <= DATE_SUB(NOW(), INTERVAL 10 DAYS) ;

MySQL说:#1064-您的SQL语法有误；请查看与您的MariaDB服务器版本相对应的手册，以在第1行的"DAYS)"附近使用正确的语法

MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DAYS)' at line 1

推荐答案

将DAYS更改为DAY，如下所示；)

Change DAYS to DAY like following;)

CREATE EVENT `UNUSED` 
ON SCHEDULE EVERY 1 HOUR 
STARTS '2016-06-14 11:00:00.000000' ENDS '2016-06-30 01:00:00.000000' 
ON COMPLETION NOT PRESERVE ENABLE DO 
UPDATE quotation_details SET status='UNUSED' WHERE updatedTime <= DATE_SUB(NOW(), INTERVAL 10 DAY) ;

并参见DATE_SUB函数参考此处.

这篇关于玛丽亚数据库中的活动时间表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！