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 > > 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 the table. > > I thought to be smart first by creating the table with no autoincrement > and second altering the table to have UID unique and autoincremet but > MySQL does not seem to like that > > I cannot modify the table to have it starting this UID=1 > > what can I do ? > > Thanks in advance > > Philippe > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
