mysql如何定时删除数据库数据

CREATE EVENT delete_data_event
  ON SCHEDULE EVERY 1 DAY
  STARTS CURRENT_TIMESTAMP
  DO
    DELETE FROM table_name WHERE condition;

#!/bin/bash
mysql -u username -p password -e "DELETE FROM table_name WHERE condition;" database_name

import mysql.connector
from datetime import datetime

def delete_data():
    # 连接到MySQL数据库
    conn = mysql.connector.connect(user='username', password='password', host='localhost', database='database_name')
    cursor = conn.cursor()

    # 执行删除数据的SQL语句
    delete_query = "DELETE FROM table_name WHERE condition"
    cursor.execute(delete_query)

    # 提交更改
    conn.commit()

    # 关闭连接
    cursor.close()
    conn.close()

# 设置每天执行的时间
scheduled_time = datetime(year=2023, month=1, day=1, hour=0, minute=0, second=0)

# 计算当前时间与执行时间的差值
current_time = datetime.now()
time_difference = scheduled_time - current_time

# 使用定时任务库执行定时删除数据
import time
time.sleep(time_difference.total_seconds())
delete_data()