【python】导出mysql数据，输出excel！

参考https://blog.csdn.net/pengneng123/article/details/131111713

import pymysql
import pandas as pd
#import openpyxl
import xlsxwriter
 
db = pymysql.connect(
    host="10.41.241.114", 
    port=***,
    user='***',
    password='***',
    charset='utf8mb4' 
    )

cursor = db.cursor() #创建游标对象
sql = 'use season;' #sql语句
cursor.execute(sql)  #执行sql语句

df=pd.read_sql("""SELECT * FROM csod_employee_training_detail_g""",con=db)
df1=pd.read_sql("""SELECT * FROM csod_training_g""",con=db)
df2=pd.read_sql("""SELECT * FROM csod_training_schedule_g""",con=db)

df.to_excel(r'csod_employee_training_detail_g.xlsx',index=False, engine='xlsxwriter')
df1.to_excel(r'csod_training_g.xlsx',index=False, engine='xlsxwriter')
df2.to_excel(r'csod_training_schedule_g.xlsx',index=False, engine='xlsxwriter')
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

openpyxl.utils.exceptions.IllegalCharacterError 错误原因分析及解决办法https://blog.csdn.net/javajiawei/article/details/97147219