python - 如何在python中使用带有mysql变量的select语句

Question

我想在 where 子句中使用带有变量的 select 语句。我对此进行了研究，查看 How to use variables in SQL statement in Python?和 Inserting Variables MySQL Using Python, Not Working 。我尝试实现所提供的解决方案，但它不起作用。错误代码

mysql.connector.errors.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 '?' at line 1

代码如下:

name = input("Write your name")
mycursor.execute("SELECT name FROM workers WHERE symbol=?", name)

我做错了什么？

Answer 1

好吧，Spike7 这正是理想的情况，

mycursor.execute("SELECT name FROM workers WHERE symbol=%s", (name,))  

或

mycursor.execute("SELECT name FROM workers WHERE symbol=?", (name,)) 

已接受的答案 the first link you given解释一切。