擅长:python、mysql、java
<p>您需要将参数放入元组:</p>
<pre><code>sql = "insert into CPU_TEMP_TABLE (CPU_TEMP, CAMERA_TEMP) values (%s, %s)"
args = (cpu_temp, float(cam_temp),)
cursor.execute(sql,args)
</code></pre>
<p>或在适当位置构造字符串:</p>
<pre><code>sql = "insert into CPU_TEMP_TABLE (CPU_TEMP, CAMERA_TEMP)
values (%s, %s)" % (cpu_temp, float(cam_temp),)
cursor.execute(sql)
</code></pre>