At 11:03 PM +0200 7/17/01, Alexander Skwar wrote:
>So sprach »Warren van der Merwe« am 2001-07-17 um 22:31:02 +0200 :
>> in my plain language there it is, but the pro's may give a more detailed
>Yeah, that's sorta how I understand it as well. Also auto_increments
>BREAK when you manually insert a row and set the column with the
>auto_inc. to 0. Doing a dump will dump the 0 just fine - but using
>the dump to rebuild the table will set the row with the 0 to 1.
Yeah, doing that is asking for trouble. So is setting AI column values
to negative numbers.
>In short, my experience is that if you use auto_incs you better do
>*NOT* touch columns with auto_inc values - especially do not modify
>them in a way mysql would not have done it itself.
Paul DuBois, paul@stripped