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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
