mysql 发邮件

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

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

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

# 准备邮件内容
msg = MIMEText(str(result))
msg['Subject'] = 'Data from MySQL'
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.send_message(msg)
smtp_server.quit()

try:
    # 发送邮件的代码（如上述示例）
    pass
except smtplib.SMTPException as e:
    print(f"Error sending email: {e}")
except mysql.connector.Error as e:
    print(f"Database error: {e}")
except Exception as e:
    print(f"An unexpected error occurred: {e}")