我想在我的数据库中增加一列,我该怎么做?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 回答

白衣非少年
TA贡献1155条经验 获得超0个赞
你想要一个update
声明。假设您的表的主键是id
,那将是:
UPDATE users SET nb_win = nb_win + 1 WHERE user_name = ?
查询中的?
应替换为您要递增id
的行的。nb_win
添加回答
举报
0/150
提交
取消