代碼為：
sql = "UPDATE denglu SET shenBaoZhuangTai = 1 WHERE gongSiId = " + str(gongsi.gongSiId)
mysql.update(sql)
拼接后的sql于是可以運行的
報錯資訊如下：
Traceback (most recent call last):
File "main.py", line 226, in <module>
data = main(denglu,gongsi, startTime)
File "main.py", line 151, in main
mysql.update(sql)
File "F:\Small-scale\util\mysql\mysql.py", line 37, in update
_res = cursor.execute(sql)
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python36\lib\site-p
ackages\pymysql\cursors.py", line 170, in execute
result = self._query(query)
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python36\lib\site-p
ackages\pymysql\cursors.py", line 328, in _query
conn.query(q)
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python36\lib\site-p
ackages\pymysql\connections.py", line 517, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python36\lib\site-p
ackages\pymysql\connections.py", line 732, in _read_query_result
result.read()
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python36\lib\site-p
ackages\pymysql\connections.py", line 1075, in read
first_packet = self.connection._read_packet()
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python36\lib\site-p
ackages\pymysql\connections.py", line 657, in _read_packet
packet_header = self._read_bytes(4)
File "C:\Users\Administrator\AppData\Local\Programs\Python\Python36\lib\site-p
ackages\pymysql\connections.py", line 699, in _read_bytes
"Lost connection to MySQL server during query (%s)" % (e,))
pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during que
ry ([WinError 10060] 由于連接方在一段時間后沒有正確答復或連接的主機沒有反應，連
接嘗試失敗。)')
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/211388.html