Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001051

Re: [PHP-DB] Autoincrement Question From: Angie Tollerson (Tollerson <email protected>)
Date: 05/10/01

I am also doing it on 3.23.33 with MyISAM recover options off, is that what is happening? like I said...if I delete record one, and add a fourth record, It DOES NOT add it as 1. But as 5. however, if I delete 4, then add a fourth again, it sets it as 4. I'm not sure if that has anything to do with my MyISAM settings or not..but there you go.

>>> CC Zona <cczona <email protected>> 05/10/01 03:11PM >>>
[quotes restored to bottom-posting order, for clarity]

> > > > 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.

> > > I will be 3 Jeff :)

> > Only if the auto increment values started at zero. Otherwise, the number
> > will be 4.

> 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 :)

What version of MySQL and table type are you getting that on? I just tried
it with a MyISAM table in 3.23.33 (insert, immediate delete, immediate
insert), and the pk incremented as expected. No re-use of values. 

-- 
CC

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected> 
For additional commands, e-mail: php-db-help <email protected> 
To contact the list administrators, e-mail: php-list-admin <email protected> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>