At 22:59 -0400 7/6/02, Brad W. Galiette wrote:
>Is there any easy way to create a column in a MySQL table which
>increments with each successive INSERT request? (I understand that
>AUTO_INCREMENT inserts a value that is one greater than the greatest that
>already exists in the table; however, this creates a problem --- from the
>position of creating a web interface --- of what occurs when the record
>holding the greatest value for the AUTO_INCREMENT column is dropped. Thus
>it would be possible to confuse two records which, in the end, would have
>had the same identifying value. Is there any work around to this issue to
>continue incrementing even if the record holding the greatest AUTO_INCREMENT
>value is deleted?
The behavior you describe (reuse of values) occurs for ISAM tables.
If you use a MyISAM table instead, values will increase monotonically,
even if DELETEs occur.
>Thank you in advance for your support!