From: "Dr.Ruud" <[EMAIL PROTECTED]>
"Octavian Rasnita" schreef:
Dr.Ruud:
Octavian Rasnita:
but the problem is that the primary key field which has
autoincrement option skips the ID of each record which is not
inserted because it is already in the database, and I don't want
that.
This skip
"Octavian Rasnita" schreef:
> Dr.Ruud:
>> Octavian Rasnita:
>>> but the problem is that the primary key field which has
>>> autoincrement option skips the ID of each record which is not
>>> inserted because it is already in the database, and I don't want
>>> that.
>>
>> This skip is normal in a mu
From: "Dr.Ruud" <[EMAIL PROTECTED]>
"Octavian Rasnita" schreef:
but the problem is that the primary key field which has autoincrement
option skips the ID of each record which is not inserted because it
is already in the database, and I don't want that.
This skip is normal in a multi-connecti
"Octavian Rasnita" schreef:
> but the problem is that the primary key field which has autoincrement
> option skips the ID of each record which is not inserted because it
> is already in the database, and I don't want that.
This skip is normal in a multi-connection environment. You allocate the
ne
Hi,
From: "Rob Dixon" <[EMAIL PROTECTED]>
Since this is a Perl forum it is helpful to use the /full syntax/ of any
SQL
that your Perl is using. (I assume you actually have some Perl behind all
this?) And in particular you should avoid abbreviating non-standard SQL,
so
that at least we have s
Octavian Rasnita wrote:
>
> I have an SQLite database that has a field with a unique constraint and I
> want to be able to insert records as fast as possible.
>
> The program works fine if I use
>
> insert or ignore into table_name...
>
> but the problem is that the primary key field which has
Hi,
I have an SQLite database that has a field with a unique constraint and I
want to be able to insert records as fast as possible.
The program works fine if I use
insert or ignore into table_name...
but the problem is that the primary key field which has autoincrement option
skips the ID
