From: Warren Young
Date: March 18 2010 8:28am
Subject: Re: insert query without primary key
List-Archive: http://lists.mysql.com/plusplus/8910
Message-Id: <52A869FA-CC81-4A30-B470-5BBA0F75857F@etr-usa.com>
MIME-Version: 1.0 (Apple Message framework v1077)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable

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.=