mysql - 在 mysql 中创建每日星期日报告

Question

如何在 mysql 中创建每日周日报告？ (每周日)

我希望将我的报告保存在网盘中。这可能吗？

例如:

CREATE EVENT myevent
    ON SCHEDULE EVERY ONE WEEK 
    DO
SELECT titlea,titleb 
FROM tableX
INTO OUTFILE '\\network\Documents\Reports\test.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'

Answer 1

几乎...，

您必须指定开始日期

CREATE EVENT `myevent ` 
ON SCHEDULE EVERY 7 DAY STARTS '2015-10-11 02:00:00' 
ON COMPLETION PRESERVE ENABLE DO
BEGIN

SELECT titlea,titleb 
FROM tableX
INTO OUTFILE '\\network\Documents\Reports\test.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';

END