擅长:python、mysql、java
<p>另一种方法是使用带有SQLAlchemy的原始SQL模式,我使用SQLAlchemy 0.9.8、python 2.7、MySQL 5.X和MySQL python作为连接器,在这种情况下,需要一个元组。我的代码如下:</p>
<pre><code>id_list = [1, 2, 3, 4, 5] # in most case we have an integer list or set
s = text('SELECT id, content FROM myTable WHERE id IN :id_list')
conn = engine.connect() # get a mysql connection
rs = conn.execute(s, id_list=tuple(id_list)).fetchall()
</code></pre>
<p>希望一切都对你有用。</p>