import pymysql
import xlwt
import numpy as np
import pandas as pd

coon=pymysql.connect(host=‘127.0.0.1‘,
                     user=‘root‘,
                     password=‘12345678‘,
                     port=3306,
                     db=‘tone‘,
                     charset=‘utf8‘,
                     autocommit=True)
cur=coon.cursor()
sql = ‘select * from logininfo‘
cur.execute(sql)
data=cur.fetchall()
#结果返回二维元组
print(data)
#结果转换为list列表，元素为元组
print(list(data))
#结果转换为dataframe形式
data_df=pd.DataFrame(list(data))
print(data_df)
#结果转化为dataframe带标题,cur.description二维元组内第一个元素为标题
title = [i[0] for i in cur.description]
data_df1 =pd.DataFrame(list(data),columns=title)
print(data_df1)

python—访问mysql数据库后结果类型转换