在建立连接时加入参数charset=’utf8’
import pymysql
import pandas.io.sql as sql
conn=pymysql.connect(host='127.0.0.1',port=3306,user='[用户名]',passwd='[密码]',db='[数据库名]',charset='utf8')
df=sql.read_sql_query("select * from [表名]",conn)
conn.close()
在建立连接时加入参数charset=’utf8’
import pymysql
import pandas.io.sql as sql
conn=pymysql.connect(host='127.0.0.1',port=3306,user='[用户名]',passwd='[密码]',db='[数据库名]',charset='utf8')
df=sql.read_sql_query("select * from [表名]",conn)
conn.close()