擅长:python、mysql、java
<pre class="lang-py prettyprint-override"><code>cursor.execute('''
INSERT INTO T_TABLE-A (TEMP,RH,DATE,COMPNAME)
VALUES
(runcmd1,runcmd2,GETDATE(),'TEST_Py')
''')
</code></pre>
<p>不会工作,因为您正在嵌入Python变量的<em>名称</em>,而不是它们的<em>值</em>。你需要做什么</p>
<pre class="lang-py prettyprint-override"><code>sql = """\
INSERT INTO T_TABLE-A (TEMP,RH,DATE,COMPNAME)
VALUES
(?, ?, GETDATE(),'TEST_Py')
"""
cursor.execute(sql, runcmd1, runcmd2)
</code></pre>