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.

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
-- 
How to quote:   http://learn.to/quote (german) http://quote.6x.to (english)
Homepage:       http://www.digitalprojects.com   |   http://www.iso-top.de
   iso-top.de - Die günstige Art an Linux Distributionen zu kommen
                Uptime: 14 hours 30 minutes

---------------------------------------------------------------------
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

Reply via email to