List:MySQL++« Previous MessageNext Message »
From:Warren Young Date:March 18 2010 8:28am
Subject:Re: insert query without primary key
View as plain text  
On Mar 17, 2010, at 8:20 PM, Chris Morgan wrote:

> MySQL treats a zero as a special value when it is in an insert statement for an
> auto-increment column

Yes, because auto-increment values always start at 1 by default, so 0 is out of range and
therefore has to be replaced with *something*.

It's already on the wishlist for SSQLS v2 to handle auto-increment columns transparently
in inserts, but that's just vaporware for now.
Thread
insert query without primary keyAndrej van der Zee18 Mar
  • Re: insert query without primary keyChris Morgan18 Mar
    • Re: insert query without primary keyAndrej van der Zee18 Mar
      • Re: insert query without primary keyChris Morgan18 Mar
        • Re: insert query without primary keyAndrej van der Zee18 Mar
        • Re: insert query without primary keyWarren Young18 Mar