That's nice :)
----- Original Message -----
From: Harald Fuchs <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 31, 2001 8:34 PM
Subject: Re: Auto-Increment - how can I avoid repeating IDs?
> In article <009f01c08b0f$c85bbec0$be66bcd4@ruscomp>,
> [EMAIL PROTECTED] ("Rus") writes:
>
> > That's strange. I thought that auto_increment field not suppose to use
same
> > value.
>
> Even worse, it's documented :-)
>
> If you delete the row containing the maximum value for an
> `AUTO_INCREMENT' column, the value will be reused with an ISAM
> table but not with a `MyISAM' table. If you delete all rows in the
> table with `DELETE FROM table_name' (without a `WHERE') in
> `AUTOCOMMIT' mode, the sequence starts over for both table types.
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php