Re: [sqlite] On conflicting Primary key how to insert record and increment the Key

that when there is a duplicate primary key then it should auto increment this primary key and insert the new record with it . P Kishor-3 wrote: > > On Mon, Mar 15, 2010 at 8:32 AM, dravid11 <ahmadrath...@gmail.com> wrote: >> >> Well the situation is that i am merging d

Re: [sqlite] On conflicting Primary key how to insert record and increment the Key

NSERT INTO temp (address, weight) > values( "blah blah", 100) > > The autoincrementing primary key will be autoincremented. > > Regards > Tim Romano > > > On 3/15/2010 9:15 AM, dravid11 wrote: >> Hello ! >> I have been trying to search for this solu

[sqlite] On conflicting Primary key how to insert record and increment the Key

Hello ! I have been trying to search for this solutions for days,yet did not find the solution. I want to write an insert query on a table. When there is a conflicting primary key then it should increment the primary key and insert the row . For example i want to run this query INSERT INTO