擅长:python、mysql、java
<p>您是否尝试过使用命名参数,即:</p>
<pre><code>sql = "Insert into Results (idResults, idClient, TestDateTime, ResultBinary, SecondResult)
Values (10, 7, '2014-11-05 14:09:11', %(one)s, %(two)s)"
cursor.execute(sql, { 'one': TheData, 'two': SecondData})
</code></pre>
<p><a href="http://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-execute.html" rel="nofollow">Reference</a></p>