mysql自动发送报表

-- 创建索引
CREATE INDEX idx_date ON your_table(date_column);

-- 优化查询
SELECT date_column, SUM(sales) AS total_sales
FROM your_table
WHERE date_column >= '2023-01-01'
GROUP BY date_column;

import smtplib
from email.mime.text import MIMEText

# 邮件配置
smtp_server = 'smtp.example.com'
smtp_port = 587
smtp_user = 'your_email@example.com'
smtp_password = 'your_password'
to_email = 'recipient@example.com'

# 创建邮件
msg = MIMEText('这是您的报表内容')
msg['Subject'] = '每日报表'
msg['From'] = smtp_user
msg['To'] = to_email

# 发送邮件
try:
    server = smtplib.SMTP(smtp_server, smtp_port)
    server.starttls()
    server.login(smtp_user, smtp_password)
    server.sendmail(smtp_user, to_email, msg.as_string())
    server.quit()
except Exception as e:
    print(f'邮件发送失败: {e}')