如何从MySQL 发送电子邮件

git clone https://github.com/mysqludf/lib_mysqludf_sys.git
cd lib_mysqludf_sys
make
sudo make install

SELECT mail('to@example.com', 'from@example.com', 'subject', 'message');

import smtplib
import mysql.connector

# 连接到MySQL数据库
cnx = mysql.connector.connect(user='username', password='password',
                              host='localhost', database='mydatabase')

# 执行查询并获取数据
cursor = cnx.cursor()
cursor.execute("SELECT email, message FROM mytable")

# 遍历结果并发送电子邮件
for (email, message) in cursor:
   # 发送电子邮件
   from_email = 'sender@example.com'
   to_email = email
   subject = 'MySQL Email'
   body = message

   # 登录到SMTP服务器并发送邮件
   server = smtplib.SMTP('smtp.gmail.com', 587)
   server.starttls()
   server.login(from_email, 'yourpassword')
   server.sendmail(from_email, to_email, f"Subject: {subject}\n\n{body}")
   server.quit()

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