查询表达式中的语法错误，SQL通过pyodbc

发布于 2025-01-28 01:02:58 字数 544 浏览 4 评论 0原文

确切的错误消息是：

programMingmingerror ：（'42000'，“ [42000] [Microsoft] [ODBC Microsoft Access驱动程序]语法错误（comma）在查询表达式中'usedied = fielse = false，electric = falese，electric = false，false，false = false，disabled，disabled，disabled = false'。（ -3100）（sqlexecdirectw）”）

我在任何地方都可以看到，但不明白我在做错什么，所讨论的行如下：

spacelist = cursor.execute("SELECT space, distance1, distance2, distance3, distance4, distance5 FROM spaces WHERE occupied = False, electric = True")

原文

The exact error message is:

ProgrammingError: ('42000', "[42000] [Microsoft][ODBC Microsoft Access Driver] Syntax error (comma) in query expression 'occupied = False, electric = False, family = False, disabled = False'. (-3100) (SQLExecDirectW)")

I've looked everywhere I can see but don't understand what I'm doing wrong, the line in question is as follows:

spacelist = cursor.execute("SELECT space, distance1, distance2, distance3, distance4, distance5 FROM spaces WHERE occupied = False, electric = True")

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

奶茶白久 2025-02-04 01:02:58

尝试以下操作：

spacelist = cursor.execute("SELECT space, distance1, distance2, distance3, 
distance4, distance5 FROM spaces WHERE occupied = False AND electric = True")

Try this :

spacelist = cursor.execute("SELECT space, distance1, distance2, distance3, 
distance4, distance5 FROM spaces WHERE occupied = False AND electric = True")

回复收藏 0 原文

~没有更多了~