python如何写到mysql_python把变量如何写入mysql

GAME_ID = s["resultSets"][0]["rowSet"][i][0]

TEAM_ID = s["resultSets"][0]["rowSet"][i][1]

PLAYER_NAME = s["resultSets"][0]["rowSet"][i][5]

db = MySQLdb.connect("localhost","root","199536abc","test")

cursor = db.cursor()

sql = """INSERT INTO PLAYER(GAME_ID,TEAM_ID,NAME)

VALUES (GAME_ID,TEAM_ID,PLAYER_NAME)"""

try:

# 执行sql语句

cursor.execute(sql)

# 提交到数据库执行

db.commit()

except:

# Rollback in case there is any error

db.rollback()现在的问题是sql语句里values后面括号里的三个不是之前定义的GAME_ID,TEAM_ID,PLAYER_NAME, 只能写固定值“21212”，1212，“nick”这样的 求解