python读取mysql

import pymysql
import pandas as pd

con = pymysql.connect(host='rm-xxxxxxxxxxx.rds.aliyuncs.com',
                          port=3306,
                          user='xxxxxxxxx',
                          password='xxxxxxxx',
                          db='mysql',
                          charset="utf8")
                          
data_sql = pd.read_sql("select * from ods.cpc limit 10", con)
data_sql.to_csv('test.csv',encoding="utf-8_sig")