原来代码
import pymysql as mysql
import pandas as pds
conn=mysql.connect(host="localhost",user="root",passwd="1557862201",db="test")
sql="select * from Student"
result=pds.read_sql(sql,conn)
我的mysql是默认字符编码为utf-8,我只是在python连接时候指定了字符集就解决问题。
import pymysql as mysql
import pandas as pds
conn=mysql.connect(host="localhost",user="root",passwd="1557862201",db="test",charset='utf8')
sql="select * from Student"
result=pds.read_sql(sql,conn)