简介:安装Python3操作mysql数据库
- python连接MySQL模块:pymysql
- 安装命令 pip install pymysql
- 快速连接测试
"""
@Project :xd_api_test
@File :db_util.py
@Author :an
@Date :2024/4/21 16:36
@Desc :
"""
import pymysql
connect = pymysql.connect(host="127.0.0.1", user="root", password="123456", database="xd_api_test")
# 使用cursor方法获取操作游标,得到一个快要执行sql语句,并且操作结果作为字典返回的游标
cursor = connect.cursor(pymysql.cursors.DictCursor)
try:
cursor.execute("select * from `case`")
data = cursor.fetchall()
print(data)
except Exception as e:
print(e)
finally:
connect.close()
结果截图: