mysql where 出错_python mysql where claus出错

我是python的新手。编写了一个小代码来连接数据库并从数据库中获取数据mysql.connector连接数据库

HTML表单用于获取名称和密码。代码如下所示

test

First Name:

Password:

python代码是从html中获取值，然后分配给名称和密码。

sql语句通过WHERE子句从数据库中获取密码

python代码

^{pr2}$

但是在赋值的where子句中出现了错误。我没有得到什么语法错误。请给出建议

错误为：ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%s' at line 1

args = (1064, "1064 (42000): You have an error in your SQL synt...n for the right syntax to use near '%s' at line 1", '42000')

errno = 1064

msg = "You have an error in your SQL syntax; check the ...n for the right syntax to use near '%s' at line 1"

sqlstate = '42000'

with_traceback =