mysql sql语句发邮件

DELIMITER //
CREATE PROCEDURE GetReport()
BEGIN
    DECLARE result TEXT;
    SELECT CONCAT('Column1: ', Column1, ', Column2: ', Column2) INTO result FROM your_table WHERE condition;
    -- 这里可以调用邮件发送功能，将result作为邮件内容
END //
DELIMITER ;

import smtplib
from email.mime.text import MIMEText

def send_email(subject, body, to_email):
    msg = MIMEText(body)
    msg['Subject'] = subject
    msg['From'] = 'your_email@example.com'
    msg['To'] = to_email

    smtp_server = 'smtp.example.com'
    smtp_port = 587
    smtp_username = 'your_email@example.com'
    smtp_password = 'your_password'

    with smtplib.SMTP(smtp_server, smtp_port) as server:
        server.starttls()
        server.login(smtp_username, smtp_password)
        server.sendmail(msg['From'], msg['To'], msg.as_string())

# 调用存储过程获取结果
# result = execute_sql_procedure('GetReport')
# send_email('Report', result, 'recipient@example.com')

CREATE EVENT SendReportDaily
ON SCHEDULE EVERY 1 DAY
DO
CALL GetReport();