On Sat, Oct 31, 2009 at 08:31:01AM -0400, D. Richard Hipp wrote:
>
> On Oct 30, 2009, at 10:25 PM, Mick wrote:
>
> > This is more FYI than needing it (as I have already worked around
> > it), but I
> > have discovered that an IGNORE constraint on an insert, when one of
> > the
> > fields in
On Oct 30, 2009, at 10:25 PM, Mick wrote:
> This is more FYI than needing it (as I have already worked around
> it), but I
> have discovered that an IGNORE constraint on an insert, when one of
> the
> fields in the constraint is NULL, will insert a duplicate record
> into the
> database.
2009/10/31 Mick :
> This is more FYI than needing it (as I have already worked around it), but I
> have discovered that an IGNORE constraint on an insert, when one of the
> fields in the constraint is NULL, will insert a duplicate record into the
> database.
>
> i.e.
>
> CREATE
This is more FYI than needing it (as I have already worked around it), but I
have discovered that an IGNORE constraint on an insert, when one of the
fields in the constraint is NULL, will insert a duplicate record into the
database.
i.e.
CREATE TABLE mytable (
ID1 INTEGER NOT NULL,
ID2
4 matches
Mail list logo