1安装 pymysql
pip3 install mymssql
2安装records
pip3 install records
3 连接数据库
db = records.Database('mysql+pymysql://root:hhuc1115@localhost/dbTh2020?charset=utf8')
注意,要用:mysql+pymysql
4 查询:
rows = db.query("select * from T_R").all(as_dict=True)
直接将查询结果转换为json数组