You shouldn't run that one query that was given...as health/mana will remain whatever it was!
You must run a query like this:
For sorcerer:
UPDATE `players` SET level="8", health_now="185", health_max="185", mana_now="35", mana_max="35" WHERE vocation="1"
Note that this is just an example, I don't know the actual table names etc.