python操作mysql1

python操作mysql

截图啊啊啊

#!/usr/bin/env python  
# encoding: utf-8

import pymysql

connection = pymysql.connect(host='localhost',
                            user='root',
                            password='',
                            db='wiki',
                            charset='utf8')
try:
    with connection.cursor() as cursor:
        sql = "select `urlname`, `urlhref` from `urls` where `id` is not null"
        count = cursor.execute(sql)
        print(count)

        #result = cursor.fetchall()
        #print(result)

        result = cursor.fetchmany(size=5)
        print(result)



finally:
    connection.close()