python - 使用 Python 2.7 将变量传递到 MySQL

Question

我一直在尝试将 Python 2.7 中变量的字符串值插入到 MySQL 语句中。我似乎无法让它工作，有人可以指出我正确的方向吗？

import MySQLdb

country_name = raw_input("Which country would you like?\n")

dbh = MySQLdb.connect(host="localhost",
                      user="boole",
                      passwd="****",
                      db="mySQL_Experiment_1")
sth = dbh.cursor()
sth.execute("""SELECT name, population FROM world WHERE name=(%s)""", (country_name))
for row in sth:
    print row[0], row[1]

它输出:

/usr/bin/python2.7 "/home/boole/Documents/Python Scripts/mySQL_Experiment_1/main.py"
Which country would you like?
Canada
Traceback (most recent call last):
  File "/home/boole/Documents/Python Scripts/mySQL_Experiment_1/main.py", line 10, in <module>
    sth.execute("""SELECT name, population FROM world WHERE name=(%s)""", (country_name))
  File "/usr/local/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 187, in execute
    query = query % tuple([db.literal(item) for item in args])
TypeError: not all arguments converted during string formatting

Process finished with exit code 1

谢谢， bool

Answer 1

试试这个

cursor.execute("SELECT name, population FROM world where name = %s", [country_name])