| 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 key | Andrej van der Zee | 18 Mar |
| • Re: insert query without primary key | Chris Morgan | 18 Mar |
| • Re: insert query without primary key | Andrej van der Zee | 18 Mar |
| • Re: insert query without primary key | Chris Morgan | 18 Mar |
| • Re: insert query without primary key | Andrej van der Zee | 18 Mar |
| • Re: insert query without primary key | Warren Young | 18 Mar |