mysql 检验email

SELECT * FROM users WHERE email REGEXP '^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\\.[A-Za-z]{2,}$';

import smtplib
from email.mime.text import MIMEText

def send_verification_email(email, verification_code):
    msg = MIMEText(f'Your verification code is: {verification_code}')
    msg['Subject'] = 'Email Verification'
    msg['From'] = 'your_email@example.com'
    msg['To'] = email

    with smtplib.SMTP('smtp.example.com', 587) as server:
        server.starttls()
        server.login('your_email@example.com', 'your_password')
        server.sendmail('your_email@example.com', email, msg.as_string())

# 示例调用
send_verification_email('user@example.com', '123456')