Re: Autoincrement Question

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 :) >>> CC Zona <cczona@nospam.invalid> 05/10/01 02:07PM >>> In article <safa95c4.095@alliancetechnologies.net>, Tollerson@alliancetechnologies.net ("Angie Tollerson") wrote: > I will be 3 Jeff :) > > > >>> "Jeff Oien" <jeff@webdesigns1.com> 05/10/01 01:13PM >>> > If I have a database that has three records and I delete the entire > third record, when another record is then added will the auto increment > number be 3 or 4? Thanks. Only if the auto_increment values started at zero. Otherwise, the number will be 4. In answer to the question the poster seems to really be asking: auto_increment doesn't go back and re-use values from deleted rows. What if you have data in other tables where a foreign key ties (undeleted) data in that table to the deleted row in the first table? If the value was re-used, then the data in the second table would suddenly be establishing a bogus relationship to the new data in the first. -- CC -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net