我想在我的数据库中增加一列,我该怎么做?
if result[0] is True and result[1] != "": # a win
your_details["score"] = your_details["score"] + 1
lbl_status["text"] = "Game over, You won! You(" + str(your_details["score"]) + ") - " \
"" + opponent_details[
"name"] + "(" + str(opponent_details["score"]) + ")"
req = 'UPDATE INTO users("nb_win") VALUES("nb_win + 1")'
infos = your_details["score"]
print(infos)
try:
cursor.execute(req, infos)
db_connection.commit()
except mysql.Error as err:
print(err)
def connect():
global your_details
if len(ent_name.get()) < 1:
tk.messagebox.showerror(title="ERROR!!!", message="You MUST enter your first name <e.g. John>")
else:
your_details["name"] = ent_name.get()
print(ent_name.get())
connect_to_server(ent_name.get())
req = 'INSERT INTO users(user_name) VALUES("'+ ent_name.get()+'")'
infos = ent_name
如果有人能帮我,谢谢你的帮助!
1条答案
按热度按时间li9yvcax1#
你想要一个
update
声明。假设表的主键是id
,即:这个
?
在查询中应替换为id
谁的那一排nb_win
你想增加。