每天定时自动触发Mysql查询

DELIMITER $$

CREATE EVENT IF NOT EXISTS DailyQueryEvent
ON SCHEDULE EVERY 1 DAY
STARTS CURRENT_DATE + INTERVAL 1 DAY
DO
BEGIN
  -- 这里写你的查询语句
  SELECT * FROM your_table WHERE date_column = CURDATE();
END$$

DELIMITER ;

from apscheduler.schedulers.blocking import BlockingScheduler
import mysql.connector

def execute_query():
    conn = mysql.connector.connect(user='your_user', password='your_password',
                                  host='your_host', database='your_database')
    cursor = conn.cursor()
    cursor.execute("SELECT * FROM your_table WHERE date_column = CURDATE()")
    result = cursor.fetchall()
    print(result)
    cursor.close()
    conn.close()

scheduler = BlockingScheduler()
scheduler.add_job(execute_query, 'cron', hour=0, minute=0)  # 每天凌晨执行
scheduler.start()