mysql可以发邮件

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

# 连接MySQL数据库
db = mysql.connector.connect(
    host="localhost",
    user="your_username",
    password="your_password",
    database="your_database"
)

cursor = db.cursor()

# 查询数据
cursor.execute("SELECT * FROM your_table")
result = cursor.fetchall()

# 构建邮件内容
msg = MIMEText(str(result))
msg['Subject'] = 'Data Report'
msg['From'] = 'your_email@example.com'
msg['To'] = 'recipient_email@example.com'

# 发送邮件
smtp_server = smtplib.SMTP('smtp.example.com', 587)
smtp_server.starttls()
smtp_server.login('your_email@example.com', 'your_email_password')
smtp_server.sendmail('your_email@example.com', 'recipient_email@example.com', msg.as_string())
smtp_server.quit()

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