python - 如何将 cursor.executemany 用于插入以外的其他操作

Question

我有这个代码：

c = conn.cursor()
l=[(A,B,C),]
c.executemany("SELECT * FROM 'my_table' WHERE code=? AND date BETWEEN ? AND ? ORDER BY date",l) 
r = c.fetchall()

我怎样才能让它工作？还有其他选择吗？

标签： pythonpython-3.x

Answer 1

c = conn.cursor()
l = (A, B, C)
c.execute("SELECT * FROM 'my_table' WHERE code=? AND date BETWEEN ? AND ? ORDER BY date", l)
r = c.fetchall()