MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:February 17 2005 4:53am
Subject:Re: auto_increment=0
View as plain text  
Hello.

Use the NO_AUTO_VALUE_ON_ZERO sql mode. See:
  http://dev.mysql.com/doc/mysql/en/server-sql-mode.html





Philippe Rousselot <linux@stripped> 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
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com



Thread
auto_increment=0Philippe Rousselot16 Feb
  • Re: auto_increment=0Gleb Paharenko17 Feb