Re: Autoincrement Question

on 5/10/01 12:59 PM, Angie Tollerson (Tollerson@alliancetechnologies.net) 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 <webmaster@gseis.ucla.edu> <http://www.gseis.ucla.edu/> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++