import pandas as pd
import MySQLdb
handle = MySQLdb.connect(host="xxx.xxx..xxx.xxx",user="root",port=xxxx, passwd="xxxxxx",db="xxxxx",charset="utf8")
sql = xxxxx #查询语句
df = pd.read_sql(sql, con=handle)
handle.close()
df.to_excel(r'./1.xlsx', sheet_name='data')
