;-)
Best regards Nils Valentin Tokyo/Japan 2003年 8月 13日 水曜日 21:29、Rudi Ahlers さんは書きました: > Great thanx, this one worked wonders > > > Kind Regards > Rudi Ahlers > +27(82) 926 1689 > > "The basic difference between an ordinary man and a warrior is that a > 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" > <[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 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 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 between an ordinary man and a warrior is that a > > warrior takes everything as a challenge while an ordinary man takes > > everything either as a blessing or a curse." > > -- > --- > Valentin Nils > Internet Technology > > E-Mail: [EMAIL PROTECTED] > URL: http://www.knowd.co.jp > Personal URL: http://www.knowd.co.jp/staff/nils > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]