mysql 查询结果发邮件

import smtplib
from email.mime.text import MIMEText
import mysql.connector

# 连接 MySQL 数据库
db = mysql.connector.connect(
    host="localhost",
    user="youruser",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

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

# 将查询结果转换为字符串
result_str = "\n".join([str(row) for row in result])

# 邮件配置
sender_email = "your_email@example.com"
receiver_email = "receiver_email@example.com"
password = "your_email_password"

message = MIMEText(result_str, 'plain')
message['Subject'] = 'MySQL Query Result'
message['From'] = sender_email
message['To'] = receiver_email

# 发送邮件
with smtplib.SMTP('smtp.gmail.com', 587) as server:
    server.starttls()
    server.login(sender_email, password)
    server.sendmail(sender_email, receiver_email, message.as_string())

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