擅长:python、mysql、java
<p>我希望juris是一个字符串列表?如果是这样,这可能会有帮助:</p>
<pre><code>myquery = ("SELECT accountid FROM asmithe.data_hash "
"WHERE percent in (%s)" % ",".join(map(str,juris)))
</code></pre>
<p>查看以下链接:</p>
<ol>
<li><p><a href="https://stackoverflow.com/questions/283645/python-list-in-sql-query-as-parameter">python list in sql query as parameter</a></p></li>
<li><p><a href="https://stackoverflow.com/questions/12563952/how-to-select-item-matching-only-in-list-in-sql-server">How to select item matching Only IN List in sql server</a></p></li>
<li><p><a href="https://docs.python.org/2/library/stdtypes.html#string-formatting" rel="nofollow noreferrer">String formatting operations</a></p></li>
</ol>