On Wed, 27 Aug 2003 09:38:16 -0400 Paul DuBois <[EMAIL PROTECTED]> wrote:
> At 9:05 -0300 8/27/03, bernardaum wrote: > >Hi, > > > >I have a table with an auto_increment field. When I > >delete all the record and insert a new one the > >auto_increment field is not clean, its follows the > >sequence. > > > >Can I restart this sequence? Start from 0 again? > > Why bother? MySQL doesn't care if there are gaps in the sequence. > And if you're using the ID to relate records in the table to records > in another table, you'll destroy the correspondence. imho, he's talking about resetting auto_increment to 0, not about gaps in ID: >When I --> delete all <-- the records ... --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
