abhishek jain wrote:
On Sat, Aug 2, 2008 at 10:49
But as per a thread on this link, if the resetted value is less than the
highest value already in table then the effective increment value will start
from highest number and not from 100.
I have deleted some rows and i want the increment to start from those
row-ids.
That can't be done. An auto-increment value must be higher than the
highest existing value. Otherwise, it would not be an auto-increment
value at all - it would be an auto-interpolate.
On a more general note, if the actual value of the primary key matters
for anything other than simply existing as a primary key, then you
shouldn't be using auto-increment at all. You should generate the value
through some other means and insert it with the value that you want it
to be.
Mark
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
