作者:dingzhi521 | 来源:互联网 | 2018-04-26 03:42
GAME_IDs["resultSets"][0]["rowSet"][i][0]TEAM_IDs["resultSets"][0]["rowSet"][i][1]PLAYER_NAMEs["resultSets"][0]["rowSet"][i][5]dbMySQLdb.connect("localhost","ro
mysqlsqlpython数据库
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”这样的 求解