Re: last_insert_id() bug ?? using INSERT IGNORE

2001-10-01 Thread marcus davy
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

Re: last_insert_id() bug ?? using INSERT IGNORE

2001-10-01 Thread Paul DuBois
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 >>

Re: last_insert_id() bug ?? using INSERT IGNORE

2001-10-01 Thread marcus davy
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

Re: last_insert_id() bug ?? using INSERT IGNORE

2001-10-01 Thread Benjamin Pflugmann
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

RE: last_insert_id() bug ?? using INSERT IGNORE

2001-09-30 Thread Will French
-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: > >

Re: last_insert_id() bug ?? using INSERT IGNORE

2001-09-30 Thread Paul DuBois
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

last_insert_id() bug ?? using INSERT IGNORE

2001-09-30 Thread marcus davy
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

last_insert_id() Bug???

2001-06-25 Thread Alexey
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+"','