擅长:python、mysql、java
<p>当我把问题打出来的时候,我想出来了。因为我在堆栈溢出上没有看到答案(我可能就是找不到答案),所以我想我应该发布这个问题,然后再回答它,以防它对其他人有帮助。关键是始终使用=?语法,然后在参数中包含IN关键字,如下所示:</p>
<pre><code>cursor = conn.cursor()
query = "Select touchtonekey, COUNT(touchtonekey) as
touchedthismanytimes from vw_callhandlertraffic\
where callhandlername = ? and createddatetime between ?\
and ? and touchtonekey = ? Group By touchtonekey Order by\
touchtonekey"
data = cursor.execute(query,'My CallHandler','2019-10-09 13:00:00',
'2019-12-09 13:59:59',"IN ('1','2')")
</code></pre>