Re: Multiple field updates

2003-08-14 Thread Nils Valentin
takes everything either as a blessing or a curse. - Original Message - From: Nils Valentin [EMAIL PROTECTED] To: Rudi Ahlers [EMAIL PROTECTED]; mysql groups [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 12:04 PM Subject: Re: Multiple field updates Hi Rudi, I would go

Re: Multiple field updates

2003-08-14 Thread Nils Valentin
Hi Cybot, Thank you for spotting that. I was a bit careless ;-) Best regards Nils Valentin Tokyo/Japan 2003 8 12 19:23Cybot : Nils Valentin wrote: Hi Rudi, I would go for the UPDATE ...SET... syntax. http://www.mysql.com/doc/en/UPDATE.html Something like UPDATE tblname SET

Re: Multiple field updates

2003-08-14 Thread Nils Valentin
Hi Rudi, I would go for the UPDATE ...SET... syntax. http://www.mysql.com/doc/en/UPDATE.html Something like UPDATE tblname SET id=id+addedvalue WHERE id BETWEEN 3999 AND 8001; Best regards Nils Valentin Tokyo/Japan 2003 8 12 18:38Rudi Ahlers : Hi Can someone please tell me howto

Re: Multiple field updates

2003-08-14 Thread Rudi Ahlers
: Nils Valentin [EMAIL PROTECTED] To: Rudi Ahlers [EMAIL PROTECTED]; mysql groups [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 12:04 PM Subject: Re: Multiple field updates Hi Rudi, I would go for the UPDATE ...SET... syntax. http://www.mysql.com/doc/en/UPDATE.html Something like UPDATE

Re: Multiple field updates

2003-08-14 Thread Cybot
Nils Valentin wrote: Hi Rudi, I would go for the UPDATE ...SET... syntax. http://www.mysql.com/doc/en/UPDATE.html Something like UPDATE tblname SET id=id+addedvalue WHERE id BETWEEN 3999 AND 8001; UPDATE tblname SET id=id+addedvalue WHERE id BETWEEN 4000 AND 8000; If expr is greater than

Multiple field updates

2003-08-12 Thread Rudi Ahlers
Hi Can someone please tell me howto update a field (which is auto_increment) for a range from say 4000 - 8000? I only want to change info for listings in that range, if my database has about 75000 listings Kind Regards Rudi Ahlers Océ Software Support +27 (11) 661-9000 The basic difference