擅长:python、mysql、java
<p>我认为您需要在字符串和此行的参数之间添加一个<code>%</code>:</p>
<pre><code>sql = "INSERT INTO get_xici(thread_name, url, proxy, status, code, speedtime, memo) VALUES('%s', '%s', '%s', '%s', '%d', '%f', '%s')" (thread_name, url, proxy, status, code, speedtime, memo)
</code></pre>
<p>收件人:</p>
<pre><code>sql = "INSERT INTO get_xici(thread_name, url, proxy, status, code, speedtime, memo) VALUES('%s', '%s', '%s', '%s', '%d', '%f', '%s')" % (thread_name, url, proxy, status, code, speedtime, memo)
</code></pre>
<p>但是一般来说,出于安全原因(防止SQL注入),您应该使用<a href="http://zetcode.com/python/pymysql/" rel="nofollow noreferrer">prepared statements</a>而不是字符串插值来生成SQL查询</p>