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