[sqlite] match ... against

hi peeps... can you suggest an sql statement that i can use in sqlite to search chunks of text like the match(...) against(...) of mysql??? thanks... ali

[sqlite] From file to memory and back...

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]

Re: [sqlite] sqlite_busy_timeout()

"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 in

Re: [sqlite] sqlite_busy_timeout()

> 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 databas

[sqlite] select on 2 tables

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 fi

[sqlite] error when using AS with JOIN USING

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 foll

Re: [sqlite] error when using AS with JOIN USING

Michael Hunley <[EMAIL PROTECTED]> writes: > 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 . name>. So, if you have table User with

[sqlite] Re: [inbox] Re: [sqlite] error when using AS with JOIN USING

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, like

[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 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'; S

RE: [sqlite] Fatal error loading large table

> -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

[sqlite] Previous mail digest

I'd like to read some think in previous digest of [EMAIL PROTECTED] Please tell me the URL. Tks

Re: [sqlite] Fatal error loading large table

On Fri, Dec 12, 2003 at 12:01:04AM +, Tom Poindexter wrote: > 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: I think large file support didn't get compiled in to my build, I confirmed with: