f\xb6\xe9\x9d\x92\xe8\x8b\x94\xe5\xbd\x92\xe8\xb7\xaf\xe3\x80\x8b'.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server
class PoemscrapyPipeline:
#写入数据库
def __init__(self):
self.connect=pymssql.connect(
host='DESKTOP-I0TJ9UD',
port=1433,
database='poemdb',
user='robot',
password='123456,
charset='utf8',
autocommit = True
)
self.cursor = self.connect.cursor()
def process_item(self, item, spider):
#写入数据库
self.cursor.execute('INSERT INTO sentence(source,sentence,url,content) VALUES ("{}","{}","{}","{}")'
.format(item['source'], item['sentence'], item['url'], item['content']))
self.connect.commit()
return item
def close_spider(self,spider):
self.cursor.close()
self.connect.close()
pymssql._pymssql.ProgrammingError: (207, b"Invalid column name '\xe7\xba\xb3\xe5\x85\xb0\xe6\x80\xa7\xe5\xbe\xb7\xe3\x80\x8a\xe5\xa6\x82\xe6\xa2\xa6\xe4\xbb\xa4\xc2\xb7\xe9\xbb\x84\xe5\x8
f\xb6\xe9\x9d\x92\xe8\x8b\x94\xe5\xbd\x92\xe8\xb7\xaf\xe3\x80\x8b'.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error mes
sage 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Ser
ver\nDB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n")
我自己查的结果都说是列名不对,我和数据库里的列名反复核对过了,顺序也核对过了,也试过新建一个数据库,但都没有解决,希望有人可以帮我看看!!