PDA

View Full Version : SQL querie actions


Polo
02-16-2005, 01:36 PM
Can someone help me with this, I think it shuld be easy..

I need the sql queries to:

- Make all users have 0 points
- Add all users 100 points
- Add specific users 1000 points :)

Thank you

Marco van Herwaarden
02-16-2005, 04:50 PM
UPDATE user set uttpoints = 0;
UPDATE user set uttpoints = uttpoints + 100;
UPDATE user set uttpoints = uttpoints + 1000 WHERE userid = 1;

Polo
02-16-2005, 05:52 PM
Thank you so much Marco!! I appreciate it :)