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 > > > > 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 _equal_ to min and expr is less than or > _equal_ to max ... > > http://www.mysql.com/doc/en/Comparison_Operators.html#IDX1157 > > >>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 -- --- 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]
