python插入sql错误

Question

当我尝试通过 SQL 将 Python 代码中收集的一些值插入到数据库中时，我在以下 Python 代码中遇到 SQL 错误。我在以粗体突出显示的代码中遇到 SQL 错误。任何帮助表示赞赏!

def add_ingredients(cursor) :
    while True:
      ingredient = raw_input("Name of ingredient (q to quit):")
      if ingredient.lower() !='q':
          num = raw_input("Number in storage: ")
          description = raw_input("description: ")
          sql = '''insert into ingredients 
             (title, amount, description)
            values
             **(:title, :amount, :description)'''**
          cursor.execute(sql,
           {"title":ingredient, "amount":num, "description":description})
          print "Added!"
      else:
          print "Okay, quitting."
          break

Answer 1

MySQL 连接器不需要这样的命名参数。如the documentation显示，您应该使用 %(var_name)s 格式进行字典插值:

 sql = '''insert into ingredients (title, amount, description)
          values (%(title)s, %(amount)s, %(description)s)'''
  cursor.execute(sql, {"title": ingredient, "amount": num, "description": description})