mysql自动跑sql发邮件

import smtplib
from email.mime.text import MIMEText
import pymysql

# 数据库连接配置
db_config = {
    'host': 'localhost',
    'user': 'root',
    'password': 'password',
    'database': 'testdb'
}

# 邮件配置
smtp_server = 'smtp.example.com'
smtp_port = 587
smtp_user = 'user@example.com'
smtp_password = 'password'
sender_email = 'sender@example.com'
receiver_email = 'receiver@example.com'

# 连接数据库
conn = pymysql.connect(**db_config)
cursor = conn.cursor()

# 执行SQL查询
sql = "SELECT * FROM users"
cursor.execute(sql)
result = cursor.fetchall()

# 生成邮件内容
email_content = "SQL查询结果：\n"
for row in result:
    email_content += str(row) + "\n"

# 发送邮件
msg = MIMEText(email_content)
msg['Subject'] = 'MySQL查询结果'
msg['From'] = sender_email
msg['To'] = receiver_email

server = smtplib.SMTP(smtp_server, smtp_port)
server.starttls()
server.login(smtp_user, smtp_password)
server.sendmail(sender_email, receiver_email, msg.as_string())
server.quit()

# 关闭数据库连接
cursor.close()
conn.close()