<p>我尝试用Python执行这个sqlite3查询。我将代码缩减到最小,sqlite.connect等可以工作。</p>
<pre><code>column = 'Pron_1_Pers_Sg'
goal = 'gender'
constrain = 'Mann'
with con:
cur = con.cursor()
cur.execute("SELECT ? FROM Data where ?=?", (column, goal, constrain))
con.commit()
rows = cur.fetchall()
for element in rows:
values.<a href="https://www.cnpython.com/list/append" class="inner-link">append</a>(element)
</code></pre>
<p>这将返回一个空列表。
如果我硬编码字符串,它就会工作并返回值。</p>