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
t; warrior takes everything as a challenge while an ordinary man takes
> everything either as a blessing or a curse."
>
> - Original Message -
> From: "Nils Valentin" <[EMAIL PROTECTED]>
> To: "Rudi Ahlers" <[EMAIL PROTECTED]>; "mysql groups
