Is there any easy way to create a column in a MySQL table which automatically 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?
Thank you in advance for your support! Regards, Brad Galiette --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
