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
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
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
: 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
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
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