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
>> approach.
>
>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.
>
>Alexander Skwar
--
Paul DuBois, [EMAIL PROTECTED]
---------------------------------------------------------------------
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