確切的錯誤資訊是:
ProgrammingError: ('42000', "[42000] [Microsoft][ODBC Microsoft Access Driver] 查詢運算式中的語法錯誤(逗號)'occupied = False,electric = False,family = False,disabled = False'。(-3100) (SQLExecDirectW)")
我到處都可以看到但不明白我做錯了什么,有問題的行如下:
spacelist = cursor.execute("SELECT space, distance1, distance2, distance3, distance4, distance5 FROM spaces WHERE occupied = False, electric = True")
uj5u.com熱心網友回復:
試試這個 :
spacelist = cursor.execute("SELECT space, distance1, distance2, distance3,
distance4, distance5 FROM spaces WHERE occupied = False AND electric = True")
轉載請註明出處,本文鏈接:https://www.uj5u.com/houduan/478485.html
上一篇:連接表時只保留不匹配的記錄
