> -Original Message-
> From: Tom Poindexter [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 11, 2003 4:01 PM
> To: [EMAIL PROTECTED]
> Subject: [sqlite] Fatal error loading large table
>
>
> I'm trying to load a fairly large table (~ 7.5 million rows,
> 1.5 gb of raw
> data) with
I'm trying to load a fairly large table (~ 7.5 million rows, 1.5 gb of raw
data) with the 'copy' command, and I'm getting a sqlite fatal error:
sqlite> copy or replace tab1 from 'tab1.can';
sqlite> select count(*) from tab1;
31624
sqlite> copy or replace tab2 from 'tab2.can';
At 05:20 PM 12/11/2003 -0500, [EMAIL PROTECTED] wrote:
Try this alternate syntax:
SELECT U.b,
I.c
FROM User U,
UserInfo I
WHERE U.a = I.a;
Thanks. I can work around it easily, but there are advantages to the AS
that might also be broken that could not be easily re-worked,
I just ran into an annoying bug using SQLite 2.8.6 on Win XP compiled from
source.
If you do a select and use the "AS 'alias'" for a table and also do a "JOIN
USING ", you get a sql error: no such column .. So, if you have table User with fields a,b and table UserInfo with
fields a,c, the
What I'm trying to do is a select on 2 tables so that the result would be 2
columns from the first table, a column from the second and another 3 columns from
the first one. I do:
select t1.a,t1.b,t2.n,t1.c,t1.d,t1.e from t1,t2 limit 3
What I get is the columns in the correct order but only the
> Correct.
Thank you.
> That depends entirely on your applications that are opening the database.
> When an application begins a transaction, the database is locked. When it
> commits or rolls back the transaction, the database is unlocked. If you
have
> long-running transactions on the
"Dennis Volodomanov" <[EMAIL PROTECTED]> writes:
> Could someone confirm this or tell me how to use the sqlite_busy_timeout()
> function? As I understood it, I have to call this function after each
> sqlite_open() call and it'll work until the sqlite_close() call, even if
> there are many calls
Hi!
Is there an easy way to copy an sqlite db from disk to memory and vice
versa?
Thanks,
Pier
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
8 matches
Mail list logo