读取mysql数据库数据

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()