email 示例：

            
              # -*- coding: utf-8 -*-

from email.mime.text import MIMEText
from email.utils import formataddr
from email.mime.application import MIMEApplication
from email.mime.multipart import MIMEMultipart
import smtplib

# 發郵件人郵箱賬號
my_mail = 'liujun@021.com'
# password
my_pwd = 'Jerry308477'
# 收件人郵箱賬號
my_user = 'liujun@021.com'

def mail():
    flag = True
    try:
        msg = MIMEMultipart()
        # 郵件內容
        msg.attach(MIMEText('附件中是沒有統計數據','plain','utf-8'))
        # 括號里的對應收件人郵箱昵稱，發件人郵箱賬號
        msg['From'] = formataddr([my_mail,my_mail])
        # 收件人昵稱，收件人郵箱
        msg['To'] = formataddr(['柳俊','liujun@021.com'])
        #  郵件主題
        msg['Subject'] = '廣告收入未統計數據'
        # 構建附件1（附件為xlsx格式的文本）
        att = MIMEApplication(open(r'E:\Jerry\20190901.xlsx','rb').read())
        att["Content-type"] = 'application/octet-stream'
        att.add_header('Content-Disposition','attachment',filter = ('utf8','','20190901.xlsx'))
        msg.attach(att)

        # SMTP服務器，騰訊企業郵箱端口是465，騰訊郵箱支持SSL(不強制)， 不支持TLS
        # qq郵箱smtp服務器地址:smtp.qq.com,端口號：456
        # 163郵箱smtp服務器地址：smtp.163.com，端口號：25
        server = smtplib.SMTP_SSL("smtp.exmail.qq.com",465)
        # 登錄服務器，括號中為發件人賬號、密碼
        server.login(my_mail,my_pwd)
        # 發送郵件，括號對應發件人賬號，收件人賬號，發送郵件
        server.sendmail(my_mail,my_user,msg.as_string())
        # 關閉連接
        server.quit()
        # 如果 try 中的語句沒有執行，則會執行下面的 flag = False
    except Exception as e:
        print(e)
        flag = False
    return flag

if __name__ == '__main__':
    result = mail()
    if result :
        print("郵件發送成功！")
    else:
        print("郵件發送失敗！")
            
          

pymysql示例：

            
              # -*- coding: utf-8 -*-
# 將 Excel 的數據寫入到mysql中

import pymysql

def connectMysql(baseName):
    #建立連接
    conn = pymysql.connect(
        host='192.168.88.99',
        user='mysql',
        passwd='mysql',
        db='test',
        port=3306,
        charset='utf8'
    )
    # 獲取游標
    cur = conn.cursor()
    # sql
    sql = "select * from student where id = '%s'" % (baseName)

    try:
        cur.execute(sql)
        conn.commit()
    except:
        conn.rollback()
    cur.close()
    conn.close()

if __name__ == '__main__':
    connectMysql("1234")
            
          

?