Hi Hawk,

(snip auto-incrementing PKs)

> is there somewhere the "next" number is located ?

No. Why would you care, anyway? The thing about PKs is that they have to be
unique, not sequential.

If you're *really* bothered by it, you'll have to dump the contents of the
table to a file, drop the table, recreate it, and import the contents into
the new table. I'd also suggest, if these numbers have to be sequential,
that you look hard at your db design to see if this is the right column to
use as a PK.

Incidentally, this is a PHP list. If you need to ask MySQL questions, please
join one of the lists at http://mysql.com/.


PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to