readmysql.py读取mysql数据库数据
# -*- coding: utf-8 -*-
import pymysql.cursors
#读取mysql数据库数据
#获取数据库链接
connection = pymysql.connect(
host='127.0.0.1',
user='root',
password='',
db='wikiurl',
charset='utf8mb4'
)
try:
# 获取会话指针
with connection.cursor() as cursor:
# 查询sql语句
sql = "select `urlname`,`urlhref` from `urls` where `id` is not null"
count = cursor.execute(sql)
print(count)
# 提交
connection.commit()
#查询数据
# result = cursor.fetchall()
result = cursor.fetchmany(3)
print(result)
finally:
connection.close()