on 5/10/01 12:59 PM, Angie Tollerson ([EMAIL PROTECTED])
wrote:
> That is true if you delete a row in between other records..if you delete 2 the
> fourth record added would be 4, not 2. BUT..in the default installation of
> mysql, if you delete the last record the auto_increment will fill it's
> place..trust me, I just tried it :)
IIRC, an older version of MySQL (3.22.X maybe) fills in the auto_increment
values, leading to the relationship problem someone else discussed. In the
later versions of MySQL (3.23.X ?) they changed this behavior to not reuse
keys unless you delete all rows from the table or something similar.
Hope that helps,
Paul
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Paul Burney
Webmaster and Open Source Developer
Educational Technology Unit
Graduate School of Education and Information Studies
University of California, Los Angeles
(310) 825-8365
<[EMAIL PROTECTED]>
<http://www.gseis.ucla.edu/>
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
