On Tue, 02 Oct 2001 14:37, Paul DuBois wrote:
> At 10:45 AM +1200 10/2/01, marcus davy wrote:
> >On Mon, 01 Oct 2001 14:44, Paul DuBois wrote:
> >> At 11:44 AM +1200 10/1/01, marcus davy wrote:
> >> >If you specify the keyword IGNORE in an INSERT, any rows that
On Mon, 01 Oct 2001 14:44, Paul DuBois wrote:
> At 11:44 AM +1200 10/1/01, marcus davy wrote:
> >If you specify the keyword IGNORE in an INSERT, any rows that duplicate
> >an existing PRIMARY or UNIQUE key in the table are ignored and are not
> >inserted.
> >But th
If you specify the keyword IGNORE in an INSERT, any rows that duplicate
an existing PRIMARY or UNIQUE key in the table are ignored and are not
inserted.
But the last_insert_id() function still appears to increment by one
in situations when the query is not adding any new information to
the tab