Hi,
General consideration:
A. Run insert in "bulk fashion":
BEGIN
INSERT INTO /* ~1 - 2000 (or more) inserts line*/
COMMIT
B. If index have complex clause please don't create index until you finish
data upload in tables.
Good look
- Original Message -
From: "J. R. W
One (and first) shoot: - try to use :
BEGIN TRANSACTION
COMMIT TRANSACTION
- Original Message -
From: "Anton Rifco"
To:
Sent: Friday, March 27, 2009 11:28 AM
Subject: [sqlite] Sqlite versus mySQL in PHP
> Hi guys,
>
> I would like to ask a question about sqlite in php. I don't
The problem:
Field UserGroup.UserGroupID is NOT declared as autoincrement field and
statement:
INSERT INTO UserGroup (UserGroupShortTitle ...
don't fill this field.
Check yourself with:
SELECT * FROM UserGroup
Check create autoincrement field : http://www.sqlite.org/faq.html#q1
CREATE TABLE
Hi cyrille,
Please try:
DELETE FROM Words WHERE IID NOT IN
( SELECT Words_ID FROM Feedbacks_has_Words )
Regards
Radu Lodina
On 2/9/06, Cyrille37 <[EMAIL PROTECTED]> wrote:
>
> Hello,
>
> I've got a SELECT query that I would like to transform as a DELETE query ,
>
Take a look to :
http://www.terrainformatica.com/sqlitedb/
Personally I don't use it, but looks nice.
Regards
Radu Lodina
On 1/30/06, John Latimer <[EMAIL PROTECTED]> wrote:
>
> Thanks for the lead, I'll go looking for it...
>
> John L>
>
> Cario
Hi - looks great.
Do you have a plan to share also the source code of server ?
Regards
Radu Lodina
On 11/11/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> This is a wrapper for SQLite that allows multiple connections accross a
> network to a single threaded SQLIte server (
Hi,
In DB2 7.x the insert statement is also ok.
On 11/3/05, Nemanja Corlija <[EMAIL PROTECTED]> wrote:
>
> > Does the check constraint fail or not? Or do different
> > database engines do different things?
> In Firebird 1.5 it does fail.
>
> Though I agree with Darren's remarks, so not failing
Hi Alfredo,
I supose you don't use
sqlite3_get_table<http://www.sqlite.org/capi3ref.html#sqlite3_get_table>function
right ?
Call another query with:
SELECT COUNT(*) AS NrRecords FROM ( )
Radu Lodina
On 10/28/05, Alfredo Cole <[EMAIL PROTECTED]> wrote:
>
> Hi:
&
of short column name deactivated
sqlite> pragma full_column_names;
1 // -> display of full column name ACTIVATED
Regards
Radu Lodina
's not a acceptable solution).
Thank you.
Regards
Radu Lodina
10 matches
Mail list logo