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" <[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: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>
>--
>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]
--
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]
