[SOLVED] Quick Way to change in Database (Help)

[PrestonParsons]

Hello.

I need some help to some database script to change whole to number 1. which is in this table

Player_levelstats with str agi sta inte spi

but now at the moment i just putting number 1 to all those but any idea how to change it faster way?
cheer :roll:

 

[Zero]

UPDATE table SET field = value, field2 = value, field3 = value WHERE x = y.
Eg UPDATE `player_levelstats` SET `agi` = 1, `sta` = 1, `str` = 1 WHERE `class` = 1 AND `level` = 1;

Be careful you don't update the whole column by not adding conditions, if I were you I'd back up the table first.

You might want to give this a read; http://www.w3schools.com/sql/sql_update.asp

 

[PrestonParsons]

UPDATE table SET field = value, field2 = value, field3 = value WHERE x = y.
Eg UPDATE `player_levelstats` SET `agi` = 1, `sta` = 1, `str` = 1 WHERE `class` = 1 AND `level` = 1;

Be careful you don't update the whole column by not adding conditions, if I were you I'd back up the table first.

You might want to give this a read; http://www.w3schools.com/sql/sql_update.asp

Thank you! that helpful though.