Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MySql
 How to make a blanket change to a colum		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

NiteOwl
Junior Member

Canada
403 Posts
Posted - 04 June 2008 :  16:59:12  Show Profile  Visit NiteOwl's Homepage
How can I make a change to a colum in the database, could somone provide me with a SQR string that I can run?

I want to edit the table MakFORUM_MEMBERS
and the colum is called m_view_policy

I want to change all instances of 1 to a zero for all members.

-=NiteOwl=-

<
-=NiteOwl=-

phy1729
Average Member

USA
589 Posts
Posted - 04 June 2008 :  17:05:44  Show Profile
UPDATE MakFORUM_MEMBERS SET m_view_policy=0 WHERE m_view_policy=1<
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts
Posted - 05 June 2008 :  04:48:39  Show Profile
If the field, as I suspect, only holds a value of 0 or 1 then there's no need for the WHERE clause.

<
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.13 seconds. Powered By: Snitz Forums 2000 Version 3.4.07