MySQL/Python语法E

Question

我经常在用python编写的SQL查询中遇到错误。你知道吗

以下是相关代码：

else:
    else_query = "SELECT count(*) FROM PARKING_SPOTS WHERE OCCUPANCY = %s"
    cursor.execute(else_query, (occupancy,)
                   " AND WHERE LOCATION = %s", (location,))

错误信息如下：

File "exp1", line 116
    " AND WHERE LOCATION = %s", (location,))
                             ^
SyntaxError: invalid syntax

有人能发现错误吗？我已经改变了很多次，包括在变量中包含部分SQL查询，但是我收到了相同的错误。你知道吗

Answer 1

• 您的查询不正确，因为您不能有2个WHERE子句
• 你只能传递一个查询字符串

所以要做到：

    else_query = """SELECT count(*) FROM PARKING_SPOTS WHERE OCCUPANCY = %s
                    AND LOCATION = %s
                 """
    cursor.execute(else_query, (occupancy, location))

查询的参数需要作为元组传递