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
> >> > duplicate an existing PRIM
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 duplicate
>> >an existing PRIMARY or UNIQUE key in the table are ignored and are not
>>
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 the last_insert_id() function still
IL PROTECTED]]
> > Sent: Sunday, September 30, 2001 10:45 PM
> > To: marcus davy; [EMAIL PROTECTED]
> > Subject: Re: last_insert_id() bug ?? using INSERT IGNORE
> >
> >
> > At 11:44 AM +1200 10/1/01, marcus davy wrote:
> > >If you specify the keyword IGNORE in an I
-Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, September 30, 2001 10:45 PM
> To: marcus davy; [EMAIL PROTECTED]
> Subject: Re: last_insert_id() bug ?? using INSERT IGNORE
>
>
> At 11:44 AM +1200 10/1/01, marcus davy 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 the last_insert_id() function still appears to increment by one
>in situations when the que
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
i have tables forward and mail with the auto_increment field - mid
i have the following sql queryes:
insert into mail(mid,gdate,folder,txt,html,email,subj,date,uid,size,attach,
attachbefore,
attachafter,message,flag)values(NULL,now(),1,'"+g_text+"','"+g_html+"','"+g_from+"','"+g_subject+"','