 |
 |
Find a programming school near you
php-db | 2001051
Date: 05/10/01
- Next message: Miles Thompson: "Re: [PHP-DB] exit code generation, php shell script/standalone"
- Previous message: Dave: "[PHP-DB] exit code generation, php shell script/standalone"
- In reply to: Angie Tollerson: "Re: [PHP-DB] Autoincrement Question"
- Next in thread: CC Zona: "Re: [PHP-DB] Autoincrement Question"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Jeff,
That depends - I'm assuming this is a MySql database because of
"auto_increment".
If the table is declared with "type = MYISAM" when you add the other record
the auto_increment number will be 4. If not it will be 3. This is important
if you are using the field which is auto_increment (ed) as a foreign key.
Check your MySQL docs just to confirm this.
Cheers - Miles
At 01:20 PM 5/10/01 -0500, Angie Tollerson wrote:
>I will be 3 Jeff :)
>
>
> >>> "Jeff Oien" <jeff <email protected>> 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.
>Jeff Oien
>
>--
>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>
-- 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>
- Next message: Miles Thompson: "Re: [PHP-DB] exit code generation, php shell script/standalone"
- Previous message: Dave: "[PHP-DB] exit code generation, php shell script/standalone"
- In reply to: Angie Tollerson: "Re: [PHP-DB] Autoincrement Question"
- Next in thread: CC Zona: "Re: [PHP-DB] Autoincrement Question"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
