"Jim McAtee" <[EMAIL PROTECTED]> wrote on 02/24/2005 04:50:11 PM:
> Say a row is inserted into a table with an auto_increment column and then > deleted before another record is inserted. When a new row is inserted, > will the value of the auto_increment column be the same as the deleted > record's, or will it be one greater? > > One greater. Once an auto_increment value is used, it's used. Gaps in these numbers are no big deal as they aren't intended for end-user consumption. They are intended to aid the DBA in uniquely identify each and every row in a table, even if those rows contain identical data in all of their other columns. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
