mySQL help please - GoFuckYourself.com

d-null · 12-04-2007, 02:06 AM

did this query:

UPDATE `BLOG_MEMBERS` SET `M_STAT` = '1' WHERE `BLOG_MEMBERS`.`MEMBER_ID` =612 LIMIT 1 ;

I am curious what the "limit 1" does?

I am curious how I would modify the syntax of the same query to automatically do all member_id from say 1 to 612?

thanks

Bro Media - BANNED FOR LIFE · 12-04-2007, 02:19 AM

limit 1 makes sure that it only updates 1 record

d-null · 12-04-2007, 03:37 AM

thanks

do I need to set up some kind of loop query to change all the records in one field?

(Im a newbie to the sql query thing)

DaveKnell · 12-04-2007, 03:56 AM

Nope - just make your where clause something like
where member_id>=1 and member_id<=612

--Dave

d-null · 12-04-2007, 03:57 AM

thanks Dave, off to experiment

donborno · 12-04-2007, 04:18 AM

Quote:

Originally Posted by DaveKnell

Nope - just make your where clause something like
where member_id>=1 and member_id<=612

--Dave

Rather use

Code:

WHERE member_id BETWEEN 1 AND 612

12-04-2007, 02:06 AM	#1
d-null . . . Industry Role: Join Date: Apr 2007 Location: NY Posts: 13,724	mySQL help please did this query: UPDATE `BLOG_MEMBERS` SET `M_STAT` = '1' WHERE `BLOG_MEMBERS`.`MEMBER_ID` =612 LIMIT 1 ; I am curious what the "limit 1" does? I am curious how I would modify the syntax of the same query to automatically do all member_id from say 1 to 612? thanks

12-04-2007, 02:19 AM	#2
Bro Media - BANNED FOR LIFE MOBILE PORN: IMOBILEPORN Join Date: Jan 2004 Location: Tinseltown NL Posts: 16,502	limit 1 makes sure that it only updates 1 record

12-04-2007, 03:37 AM	#3
d-null . . . Industry Role: Join Date: Apr 2007 Location: NY Posts: 13,724	thanks do I need to set up some kind of loop query to change all the records in one field? (Im a newbie to the sql query thing)

12-04-2007, 03:56 AM	#4
DaveKnell Registered User Join Date: May 2001 Location: London, England Posts: 76	Nope - just make your where clause something like where member_id>=1 and member_id<=612 --Dave

12-04-2007, 03:57 AM	#5
d-null . . . Industry Role: Join Date: Apr 2007 Location: NY Posts: 13,724	thanks Dave, off to experiment