import pandas as pd
import pymysql
con = pymysql.connect(host = "localhost",
user = "root", password = '12',
db = "test", charset='utf8')
#charset用于修正中文输出为问号的问题
sql = "select * from score;"
df = pd.read_sql(sql, con)
con.close()