"""
读取MySQL数据
1.#得到总记录数
cursor.execute0)
2.#查询下一行
cursor.fetchone()
3.#得到指定大小
cursor.fetchmany(size=None)
4.#得到全部
cursor.fetchall()
5.#关闭
connection.close)
"""
import pymysql.cursors
# 获取会话
db = pymysql.connect(user="root",
host="localhost",
password="admin",
port=3306,
db="wikiurl",
)
def select_test():
try:
# 获取执行指针
with db.cursor() as cursor:
# 不要使用select * ,太浪费计算机资源
# limit num 分页查询,作用于 fetchall()
sql = "select `urlname`,`urlhref` from `urls` where `id` is not null limit 10 "
# 返回满足查询条件的个数
count = cursor.execute(sql)
# 打印所有满足条件的结果,
print("==========count===========")
# 打印返回个数
print(count)
print("==========fetchmany=========")
# 逐条打印
for i, link in zip(range(count), cursor.fetchmany(3)):
print(i, "=", link)
print("=========fetchall===========")
# 逐条打印
for i, link in zip(range(count), cursor.fetchall()):
print(i, "=", link)
# 提交事务
db.commit()
except Exception as e:
print(e)
finally:
# 关闭资源链接
cursor.close()
db.close()
if __name__ == '__main__':
select_test()
pymysql操作之------------数据查询
最新推荐文章于 2024-07-08 21:15:10 发布