将数据传入mysql与查询

  #获取数据库链接
        connection = pymysql.connect(
            host='localhost',
            user='root',
            password='root',
            db='wikiurl',
            charset='utf8mb4'
        )
        try:
            #获取会话指针
            with connection.cursor() as cursor:
              #创建SQL语句
              sql = "insert into `urls` (`urlname`,`urlhref`) values(%s,%s)"
              #执行sql语句
              cursor.execute(sql,(url.get_text(),"https://en.wikipedia.org" + url["href"]))
              #提交
              connection.commit()

        finally:
              #关闭
              connection.close()

结果

#引入开发包
import  pymysql.cursors

#获取数据库链接
connection = pymysql.connect(
            host='localhost',
            user='root',
            password='root',
            db='wikiurl',
            charset='utf8mb4'
        )
try:
    #获取会话指针
    with connection.cursor() as cursor:
        #查询语句
        sql = "select `urlname`,`urlhref` from `urls` where `id` is not null "
        count = cursor.execute(sql)
        print(count)
        #查询数据
        result1=cursor.fetchall()#得到所有
        result=cursor.fetchmany(size=3)#得到前三条
        print(result)

finally:
    connection.close()

查询结果