我有以下代码:
import sqlite3
conn = sqlite3.connect('wereldzaak.sqlite')
curs = conn.cursor()
x = curs.execute('''SELECT SUM(price)
FROM purchase, product
WHERE dt_iso BETWEEN ‘2015-01-01' AND ‘2015-12-31’ ''')
但是当我运行它时,我得到以下错误:
WHERE dt_iso BETWEEN ‘2015-01-01' AND ‘2015-12-31’ ''')
sqlite3.OperationalError: unrecognized token: "' AND ‘2015-12-31’ "
我在网上查了一下,但还是不知道我的代码怎么了
你有两个问题
相关问题 更多 >
编程相关推荐