python操作sqlite时,写了这样一条语句:
("""SELECT (content, describe, id) FROM DAILYTASK WHERE needcopy=? AND finish=? AND uid=?""", (1, 0, uid, ))
报错:OperationalError: row value misused
这个错误的原因是SELECT后面不小心加了括号,删去括号变为:
("""SELECT content, describe, id FROM DAILYTASK WHERE needcopy=? AND finish=? AND uid=?""", (1, 0, uid, ))
即可。