#导入MySQL包,安装方式pip install pymysql
import pymysql
import pandas as pd
#创建数据库本地链接
con = pymysql.connect(host = 'localhost',
port = 3306,
user = 'root',
password = 'root',
database = 'mysql',
charset = 'utf8mb4')
#创建操作游标
cur = con.cursor()
#创建需要查询的sql语句
sql = 'select * from txhyTable'
try:
cur.execute(sql)
#接受全部内容
fy = cur.fetchall()
print(fy)
except Exception as e:
print(e)
finally:
cur.close()
con.close()
#利用pandas格式获取的内容,数据库获取的数据为list格式
data = pd.DataFrame(list(fy))
data