al 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 for the UPDATE ...SET... s
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:38、Rudi Ahlers さんは書きました:
> Hi
>
> Can someone please t
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 or
Hi Cybot,
Thank you for spotting that. I was a bit careless ;-)
Best regards
Nils Valentin
Tokyo/Japan
2003年 8月 12日 火曜日 19:23、Cybot さんは書きました:
> Nils Valentin wrote:
> > Hi Rudi,
> >
> > I would go for the UPDATE ...SET... syntax.
> >
> > http://www.mysql.com/doc/en/UPDATE.html
> >
> > Somethin
"
> <[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 tblname
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 be
