擅长:python、mysql、java
<p>修正了!</p>
<p>无论实际类型如何,都需要始终使用%s:</p>
<p>更改代码:</p>
<pre><code> c.execute("""INSERT INTO data (Vrms, Irms, RP, AP, PF, CPS, UP, BV, BI, WI, EI, temp_BP, gridOK, genON, genOK)
VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s )""",
(Vrms, Irms, RP, AP, PF, CPS, UP, BV, BI, WI, EI, temp_BP, gridOK, genON, genOK))
</code></pre>
<p>在<a href="https://stackoverflow.com/questions/775296/python-mysql-parameterized-queries">Python MySQL Parameterized Queries</a>上找到答案</p>
<p>谢谢大家!</p>