要插入到邮件表中的for循环

import pymysql

# 假设已经连接到数据库，并创建了一个名为"email_db"的数据库

# 邮件列表
emails = [
    {"sender": "sender1@example.com", "recipient": "recipient1@example.com", "subject": "Subject 1", "content": "Content 1"},
    {"sender": "sender2@example.com", "recipient": "recipient2@example.com", "subject": "Subject 2", "content": "Content 2"},
    {"sender": "sender3@example.com", "recipient": "recipient3@example.com", "subject": "Subject 3", "content": "Content 3"}
]

# 遍历邮件列表，并插入到邮件表中
for email in emails:
    # 构建插入语句
    insert_sql = f"INSERT INTO email_table (sender, recipient, subject, content) VALUES ('{email['sender']}', '{email['recipient']}', '{email['subject']}', '{email['content']}')"

    # 执行插入操作
    cursor.execute(insert_sql)

# 提交事务
connection.commit()

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