Python 3更新MySQL数据库表(Python 3 Update MySQL database table)

 我刚刚找到了用于将Python连接到MySQL数据库的pymysql模块。 我有一个数据库设置了一个名为'loot'的表，loot包含一个名为'wins'的列。 我的代码包含一个名为'won'的变量，它在SQL行之前得到一个值。 我希望将变量'won'输入id = 1的'wins'列。 数据库中已存在id = 1行。 
 
 下面的代码抛出错误pymysql.err.InternalError: (1054, "Unknown column 'won' in 'field list'") 
 
 我的问题：为什么我收到此错误以及我做错了什么？ 
 
 代码： 
 
import pymysql

# Open database connection
db = pymysql.connect(host='*******',user='******',password='*****',db='******')

# prepare a cursor object using cursor() method
cursor = db.cursor()

won=1

# Prepare SQL query to UPDATE required records
sql = "UPDATE loot SET wins = won WHERE id = 1"

# Execute the SQL command
cursor.execute(sql)

# Commit your changes in the database
db.commit()

# disconnect from server
db.close()

I have just found the pymysql module for connecting Python to a MySQL database. I have a database set up with a table named 'loot', loot contains a column called 'wins'. My code contains a variable named 'won' that is given a value right before the SQL line. I want the variable 'won' to be entered into the 'wins' column where id=1. The id=1 row already exists in the database.
 
The code below throws an error pymysql.err.InternalError: (1054, "Unknown column 'won' in 'field list'")
 
My Question: Why am I getting this error and what am I doing incorrectly?
 
The Code: 
 
import pymysql

# Open database connection
db = pymysql.connect(host='*******',user='******',password='*****',db='******')

# prepare a cursor object using cursor() method
cursor = db.cursor()

won=1

# Prepare SQL query to UPDATE required records
sql = "UPDATE loot SET wins = won WHERE id = 1"

# Execute the SQL command
cursor.execute(sql)

# Commit your changes in the database
db.commit()

# disconnect from server
db.close()

原文：https://stackoverflow.com/questions/43163196