Re: auto_increment=0

2005-02-17 Thread Gleb Paharenko
Hello. Use the NO_AUTO_VALUE_ON_ZERO sql mode. See: http://dev.mysql.com/doc/mysql/en/server-sql-mode.html Philippe Rousselot <[EMAIL PROTECTED]> wrote: > hi, > > I am migrating a DB having a table with a UID not_null autoincrement > > the original table starts at UID=0 >

auto_increment=0

2005-02-16 Thread Philippe Rousselot
hi, I am migrating a DB having a table with a UID not_null autoincrement the original table starts at UID=0 I cannot migrate this table autmaticaly as the line for UID=0 is automatically transformed into UID=1 and therefore I get an error message for the next line (UID=1) as being already into t