List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:January 9 2008 10:39am
Subject:Re: why in procedure truncate table do not reset auto_increment?
View as plain text  

> >>>>> [...] why in procedure TRUNCATE table
> >>>>> demo do not reset auto_increment?
> >>>> is clearly written in the documentation, just read ...
> >>>>
> >>>> in short:
> >>>>
> >>>> auto_increment is used for primary key, primary keys could be
> >>>> referenced
> >>>> from another table, setting auto_increment back to 0 could lead to
> >>>> using a
> >>>> primary key formerly used by another datarow and still referenced
> by
> >>>> another
> >>>> table - could lead to data inconsistency.
> >>> lol, but TRUNCATE empties the table... What good are your references?
> >>
> >> it is better to have references leading to 'nothing' than to a wrong
> >> datarow
> >> ... i think this is very easy to understand - better save than sorry!
> >
> > Why is a row with an invalid reference better? It's invalid data and you
> > just corrupted your database.
>
> please define 'invalid' - i think invalid is it in booth cases, so an
empty
> invalid is better than a wrong invalid, or not?

IMO, you're f***ed in both cases :-)

> better have an unpayed bill leading to no costumer than to a wrong
customer

Why is that better? If you TRUNCATEd the table, you know you're doing
something wrong/your data is messed up.

As I said, what I wanted to point out is that this piece in the
documentation
is a bit strange.


Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Thread
why in procedure truncate table do not reset auto_increment?过客7 Jan
  • Re: why in procedure truncate table do not reset auto_increment?Sebastian Mendel9 Jan
    • Re: why in procedure truncate table do not reset auto_increment?x9 Jan
      • Re: why in procedure truncate table do not reset auto_increment?Sebastian Mendel10 Jan
  • Re: why in procedure truncate table do not reset auto_increment?Martijn Tonies9 Jan
    • Re: why in procedure truncate table do not reset auto_increment?Sebastian Mendel9 Jan
  • Re: why in procedure truncate table do not reset auto_increment?Martijn Tonies9 Jan
    • Re: why in procedure truncate table do not reset auto_increment?Sebastian Mendel9 Jan
  • Re: why in procedure truncate table do not reset auto_increment?Martijn Tonies9 Jan
    • Re: why in procedure truncate table do not reset auto_increment?Sebastian Mendel9 Jan