Ravens PHP Scripts: Forums
 

 
  Forum Index  •  Forum FAQ  •  Search  •  Memberlist  •  Usergroups  •  Profile  •  Log in to check your private messages  •  Log in

I need to change a value of 1 to a value of 0
 View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> MySQL
Author Message
blith
Client



Joined: Jul 18, 2003
Posts: 977
PostPosted: Thu Dec 23, 2004 9:31 am Reply with quote
for a whole table. What is the SQL command to do this. Thank you.

Specifically, I need to change everyone's user_level from one number to another.
 
View user's profile Send private message Visit poster's website
Raven
Site Admin/Owner



Joined: Aug 27, 2002
Posts: 17088
PostPosted: Thu Dec 23, 2004 12:34 pm Reply with quote
UPDATE nuke_users SET user_level=0 WHERE user_level=1;
 
View user's profile Send private message
blith
PostPosted: Thu Dec 23, 2004 1:19 pm Reply with quote
Thank you!!!
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> MySQL


 Jump to:   




View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©