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]