mysql integrityerror_scrapy_pymysql.err.IntegrityError: (1062, "Duplicate entry '1' for key 'PRIMARY...

问题描述：

python：3.6

ubantu：5.4.0-6ubuntu1~16.04.4

在使用scrapy为框架，将采集到的数据使用pymysql保存到虚拟机中的时候，数据采集没有问题，但是在插入的时候出现了问题，报错如下：

[code]Traceback (most recent call last):

File "e:\anaconda3\lib\site-packages\twisted\internet\defer.py", line 654, in _runCallbacks

current.result = callback(current.result, *args, **kw)

File "E:\Scrapy\Jianshu\Jianshu\pipelines.py", line 36, in process_item

self.update(item)

File "E:\Scrapy\Jianshu\Jianshu\pipelines.py", line 31, in update

self.cursor.execute(update_time)

File "e:\anaconda3\lib\site-packages\pymysql\cursors.py", line 170, in execute

result = self._query(query)

File "e:\anaconda3\lib\site-packages\pymysql\cursors.py", line 328, in _query

conn.query(q)

File "e:\anaconda3\lib\site-pa