关联到mysql数据库的爬虫,官方给的模板代码是
import pymysql
conn = pymysql.connect(host='127.0.0.1',unix_socekt='/tmp/mysql.sock',user='root',passwd=None,db='mysql')
cur = conn.cursor()
cur.execute("USE scraping")
conn = pymysql.connect(host='127.0.0.1',unix_socekt='/tmp/mysql.sock',user='root',passwd=None,db='mysql')
cur = conn.cursor()
cur.execute("USE scraping")
cur.execute("SELECT * FROM pages WHERE id=3")
print(cur.fetchone())
cur.close()
conn.close()
print(cur.fetchone())
cur.close()
conn.close()
试运行后报错TypeError: __init__() got an unexpected keyword argument 'unix_socekt'(没有unix_socket关键字)
于是将unix_socekt='/tmp/mysql.sock'改成port=3306成功通过并且实现了打印功能。