#连接数据库
from peewee import *
导入必要模块
import pandas as pd
初始化数据库连接,使用pymysql模块
MySQL的用户:root, 密码:root, 端口:3306,数据库:test
#def user ()
db = MySQLDatabase(
database = ‘test’,# string数据库名
passwd = ‘root’, # string密码
user = ‘root’, # string用户
host = ‘localhost’, # string数据库地址IP
port = 3306, # int, 端口
)
查询语句,选出employee表中的所有数据
sql = ‘’’
select * from user;
‘’’
#连接数据库和执行sql
df = pd.read_sql_query(sql, db)
print(df)#打印sql查处的内容