擅长:python、mysql、java
<p>如果您只需要一个带参数的查询,那么不要使用元组,一个元素元组将有一个逗号</p>
<p>根据您的方法,您可以这样做(使用join):</p>
<pre><code>l = ['10030']
query_param = ",".join(l)
query = f'select * from table1 where task_id in ({query_param}) query_temp'
print(query)
</code></pre>
<p><strong>输出:</strong></p>
<blockquote>
<p>select * from table1 where task_id in (10030) query_temp</p>
</blockquote>
<p>如果列表包含多个元素,则:</p>
<pre><code>l = ['10030','111','22']
query_param = ",".join(l)
query = f'select * from table1 where task_id in ({query_param}) query_temp'
print(query)
</code></pre>
<p><strong>输出:</strong></p>
<blockquote>
<p>select * from table1 where task_id in (10030,111,22) query_temp</p>
</blockquote>