import pymysql as mysql
import pandas as pd
con = mysql.connect(host="*.*.*.*",port=3306,user="**",passwd="**",db="my_db",charset="utf8mb4")
mycursor = con.cursor()
print("连接成功")
# 查询
sql = "SELECT * FROM my_db.my_table;"
result = pd.read_sql(sql,con=con)
result.to_csv('**.csv')
PS:
- my_db:库名
- my_table:表名