我想清除此表中名为“stats”的一些列，想要将其值更改为零
columns = skills, kills, deaths, hs, tks, shots, hits, dmg, bombdef, bombdefused, bombplants, bombexplosions, h_0, h_1,h_2,h_3,h_4,h_5,h_6,h_7,roundt,wintroundct,winct,assists, connection_time, connects
想要将所有值更改为零
有人可以帮助我吗？我对mysql了解不多
答案1
它不是mysql，这只是sql
update stats set skills=0, kills=0, ... repeat for each column
读一本教科书：https://www.amazon.com/Understanding-SQL-Martin-Gruber/dp/0895886448