获取保存的页面数据content = soup.find_all('div',{'class':'single-content'})
pymysqlcon = pymysql.connect(
host='127.0.0.1',
user='root',
password='root',
db='spider',
charset="utf8mb4"
)try:
with pymysqlcon.cursor() as cursor:
sql = "insert into `content`(`content`) values(%s)"
cursor.execute(sql,(content))
pymysqlcon.commit()
finally:
pymysqlcon.close()
报错以下:
Traceback (most recent call last):
File "D:/pycharm/index.py", line 33, in
cursor.execute(sql,(content))
File "D:\Python\lib\site-packages\pymysql\cursors.py", line 168, in execute
query = self.mogrify(query, args)
File "D:\Python\lib\site-packages\pymysql\cursors.py", line 147, in mogrify
query = query % self._escape_args(args, conn)
File "D:\Python\lib\site-packages\pymysql\cursors.py", line 122, in _escape_args
return tuple(conn.literal(arg) for arg in args)
File "D:\Python\lib\site-packages\pymysql\cursors.py", line 122, in
return tuple(conn.literal(arg) for arg in args)
File "D:\Python\lib\site-packages\pymysql\connections.py", line 846, in literal
return self.escape(obj, self.encoders)
File "D:\Python\lib\site-packages\pymysql\connections.py", line 839, in escape
return converters.escape_item(obj, self.charset, mapping=mapping)
File "D:\Python\lib\site-packages\pymysql\converters.py", line 27, in escape_item
val = encoder(val, mapping)
File "D:\Python\lib\site-packages\pymysql\converters.py", line 118, in escape_unicode
return u"'%s'" % _escape_unicode(value)
File "D:\Python\lib\site-packages\pymysql\converters.py", line 73, in _escape_unicode
return value.translate(_escape_table)
TypeError: 'NoneType' object is not callable