[SQL Query] Make every player level 1 with 185 HP and 35 Mana

[Justin123456]

Is there any way that I can use an SQL Query that will change the Level (8), HP (185), and the Mana (35) of each player?
I've searched but I couldn't find anything : /

I'll REP whoever helps
Thanks everyone!

- - - Updated - - -

Woops! I messed up in the title... It's supposed to be Level 1 with 185 Health and 35 Mana : /

 

[Nutaharion]

For each player:

UPDATE `players` SET `level` = 8, `health` = 185, `healthmax` = 185, `mana` = 35, `manamax` = 35 WHERE `name` = "TYPE_NAME_HERE";

For all players:

UPDATE `players` SET `level` = 8, `health` = 185, `healthmax` = 185, `mana` = 35, `manamax` = 35;

 

[Chuck88]

Here:

UPDATE `players` SET `level` = 1, `health` = 185, `healthmax` = 185, `mana` = 35, `manamax` = 35, `cap` = 1000;

 

[Justin123456]

Thank you so much It worked!

Edit: Chuck I tried giving you REP but it said I have to spread some more reputation before I can give it to you again I'm sorry : / I'll try to give it to you later when I can!

 

[Chuck88]

np