sql help

[Murz]

Hello, is it possible reset all players stats without delete sql table ?

leaving only trhis part
username varchar(64) COLLATE utf8_lithuanian_ci NOT NULL,
password varchar(64) COLLATE utf8_lithuanian_ci NOT NULL,

CREATE TABLE IF NOT EXISTS `rcsgo_player2` (
  `username` varchar(64) COLLATE utf8_lithuanian_ci NOT NULL,
  `password` varchar(64) COLLATE utf8_lithuanian_ci NOT NULL,
  `patirtis` int(11) NOT NULL,
  `kills` int(11) NOT NULL,
  `killers` int(11) NOT NULL,
  `points` int(11) NOT NULL,
  `keys` int(11) NOT NULL,
  `chests` varchar(512) COLLATE utf8_lithuanian_ci NOT NULL,
  `rang` int(11) NOT NULL,
  `rounds` int(11) NOT NULL,
  `skins` varchar(512) COLLATE utf8_lithuanian_ci NOT NULL,
  `using_skins` varchar(512) COLLATE utf8_lithuanian_ci NOT NULL,
  `skins_kills` varchar(512) COLLATE utf8_lithuanian_ci NOT NULL,
  `kontraktas` int(11) NOT NULL,
  `contract` varchar(512) COLLATE utf8_lithuanian_ci NOT NULL,
  `contracts` varchar(512) COLLATE utf8_lithuanian_ci NOT NULL,
  `covert` varchar(512) COLLATE utf8_lithuanian_ci NOT NULL,
  `party_slots` int(11) NOT NULL,
  PRIMARY KEY (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_lithuanian_ci;

 

[RockTheStreet]

TRUNCATE

 

[Ayk]

Afaik, UPDATE without WHERE will affect all rows.
Try, "UPDATE table SET patirtis = 0, kills = 0, etc.;"

 

[Murz]

Afaik, UPDATE without WHERE will affect all rows.
Try, "UPDATE table SET patirtis = 0, kills = 0, etc.;"

thank you