I would suggest developing a link (read: programmer controlled foreign key)
over columns that would have a consistent repeatable meaning. This would
allow the developer the ability to rebuild keys and relationships with
programmer developed utilities without dependence upon the underlying file
handler or database.
Just my opinion...
Pat...
[EMAIL PROTECTED]
BTW I believe you would need to roll your own auto increment to accomplish
your desire.
----- Original Message -----
From: "Viken Nokhoudian" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 3:57 PM
Subject: Auto-Increment - how can I avoid repeating IDs?
> I am using MySQL ver. 3.22.32
>
> When a table has an auto-incrementing ID field and the last inserted
> record had an ID of, say, 100, then I delete that record, the database
> engine will re-use the 100 value. How can I get the engine to never
> repeat an ID value to avoid corrupted data correlations?
>
>
> ---------------------------------------------------------------------
> 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
>
---------------------------------------------------------------------
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
