需要pymysql包
import pymysql.cursors
# 连接MySQL数据库
connection = pymysql.connect(host='127.0.0.1', port=3306, user='root', password='hcl3533036', db='test', charset='utf8mb4', cursorclass=pymysql.cursors.DictCursor)
# 通过cursor创建游标
cursor = connection.cursor()
# 执行数据查询
sql = "SELECT `id`, `username`,`password` FROM `user_info`"
cursor.execute(sql)
#查询数据库单条数据
result = cursor.fetchone()
print(result)
print("-----------华丽分割线------------")
# 执行数据查询
sql = "SELECT `id`, `username`,`password` FROM `user_info`"
cursor.execute(sql)
#查询数据库多条数据
result = cursor.fetchall()
for data in result:
print(data)
# 关闭数据连接
connection.close()
输出:
{'id': '1', 'username': 'hcl', 'password': '123'}
-----------华丽分割线------------
{'id': '1', 'username': 'hcl', 'password': '123'}
{'id': '2', 'username': 'ln', 'password': '456'}