Need SQL command help... - GoFuckYourself.com

uno · 01-28-2006, 05:35 PM

I need to change 30,000 variables all from 0 to 1 in a column in a table in sql...

Can anyone give me the command line?

kernelpanic · 01-28-2006, 05:36 PM

UPDATE `tablename` SET `columnname`='1';

swedguy · 01-28-2006, 05:49 PM

UPDATE tablename SET columnname=1 WHERE columnname=0

incase you have other numbers than 0 and 1 in that column

kernelpanic · 01-28-2006, 05:50 PM

He said that all the variables were 0, though

Sly · 01-28-2006, 05:52 PM

DELETE tablename

uno · 01-28-2006, 07:40 PM

hmm i don't want to change the column name, just the values in the column

uno · 01-28-2006, 07:45 PM

Maybe

Update columnname where value = 0 set value =1?

again i have non clue about the syntax

Linguist · 01-28-2006, 07:55 PM

Here you go:

update tablename set columnname=1 where columname=0

uno · 01-28-2006, 08:31 PM

I totally heart you.

01-28-2006, 05:35 PM	#1
uno RIP Dodger. BEST.CAT.EVER Industry Role: Join Date: Dec 2002 Location: NYC Area Posts: 18,450	Need SQL command help... I need to change 30,000 variables all from 0 to 1 in a column in a table in sql... Can anyone give me the command line? __________________ -uno icq: 111-914 CrazyBabe.com - porn art MojoHost - For all your hosting needs, present and future. Tell them I sent ya!

01-28-2006, 05:36 PM	#2
kernelpanic Too lazy to set a custom title Join Date: Jan 2005 Posts: 2,961	UPDATE `tablename` SET `columnname`='1'; __________________ ZangoCash - Turn Your Traffic Into Ca$h. $.40 Per Install - No Tier

01-28-2006, 05:50 PM	#4
kernelpanic Too lazy to set a custom title Join Date: Jan 2005 Posts: 2,961	He said that all the variables were 0, though __________________ ZangoCash - Turn Your Traffic Into Ca$h. $.40 Per Install - No Tier

01-28-2006, 05:52 PM	#5
Sly Let's do some business! Industry Role: Join Date: Sep 2004 Location: Austin, TX Posts: 31,333	DELETE tablename __________________ Vacares - Web Hosting, Domains, O365, Security & More - Paxum and BTC Accepted Windows VPS now available Great for TSS, Nifty Stats, remote work, virtual assistants, etc. Click here for more details.

01-28-2006, 07:40 PM	#6
uno RIP Dodger. BEST.CAT.EVER Industry Role: Join Date: Dec 2002 Location: NYC Area Posts: 18,450	hmm i don't want to change the column name, just the values in the column __________________ -uno icq: 111-914 CrazyBabe.com - porn art MojoHost - For all your hosting needs, present and future. Tell them I sent ya!

01-28-2006, 05:49 PM	#3
swedguy Confirmed User Industry Role: Join Date: Jan 2002 Posts: 7,981	UPDATE tablename SET columnname=1 WHERE columnname=0 incase you have other numbers than 0 and 1 in that column

01-28-2006, 07:45 PM	#7
uno RIP Dodger. BEST.CAT.EVER Industry Role: Join Date: Dec 2002 Location: NYC Area Posts: 18,450	Maybe Update columnname where value = 0 set value =1? again i have non clue about the syntax __________________ -uno icq: 111-914 CrazyBabe.com - porn art MojoHost - For all your hosting needs, present and future. Tell them I sent ya!

01-28-2006, 07:55 PM	#8
Linguist Confirmed User Join Date: Apr 2004 Location: Toronto, ON Posts: 1,706	Here you go: update tablename set columnname=1 where columname=0

01-28-2006, 08:31 PM	#9
uno RIP Dodger. BEST.CAT.EVER Industry Role: Join Date: Dec 2002 Location: NYC Area Posts: 18,450	I totally heart you. __________________ -uno icq: 111-914 CrazyBabe.com - porn art MojoHost - For all your hosting needs, present and future. Tell them I sent ya!