【Python】导出mysql数据到xlsx/csv

import pandas as pd 
import xlrd
import pymysql

file_path=r"C:\result.xlsx"

mysql_conn=pymysql.connect(
    host='localhost',
    port=3306,
    user='root',
    password='***',
    database='aaa')

sql="select * from test"
df=pd.read_sql(sql,mysql_conn)

#xlsx导出
df.to_excel(file_path,index=False)

#csv导出

df.to_csv(file_path,index=False,encoding="utf_8_sig")
print('ok')