Hi, I have a table in my database that has players details, one set of these details are crystal_asteroids and metal_asteroids!
I was wondering if their was a mysql query that I could run that would add the value 1000 to each of details. It msut add it to every player in the table!
For example if player 34 had currently 354 crystal_asteroids and 354 metal_asteroids, I would like to add 1,000 of each so he has a nw total of 1,354 crysatl_asteroids and 1,354 metal asteroids.
To manually change this for every player is very time consumming as seen as there is over 100 players!
Is there a query I could run then??
Thanks Very much in advance
Iklekid