Re: [sqlite] Getting a list of items on a column

Thanks. - Original Message - From: "C.Peachment" <[EMAIL PROTECTED]> To: Sent: Saturday, May 05, 2007 9:40 PM Subject: Re: [sqlite] Getting a list of items on a column On Sat, 5 May 2007 21:03:27 -0400, jose isaias cabrera wrote: Ok, I am going to push

Re: [sqlite] Getting a list of items on a column

Thanks. Yes, that works. - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Saturday, May 05, 2007 9:37 PM Subject: Re: [sqlite] Getting a list of items on a column "jose isaias cabrera" <[EMAIL PROTECTED]> writes: "C.Peachment" wrote, On Sat,

Re: [sqlite] Getting a list of items on a column

On Sat, 5 May 2007 21:03:27 -0400, jose isaias cabrera wrote: >Ok, I am going to push my luck. :-) Imagine the same data, what if I >wanted to get the sum of the other two columns also? I know how to do it >one at a time, so in this instance I would have to do 3 separate call using >sum or

Re: [sqlite] Getting a list of items on a column

"jose isaias cabrera" <[EMAIL PROTECTED]> writes: > "C.Peachment" wrote, > > >> On Sat, 5 May 2007 19:58:19 -0400, jose isaias cabrera wrote: >> >> >>>Greetings! >> >>>imagine this data content, >> >>>c1, c2, c3 >>>a, 1, 2 >>>b, 3, 4 >>>c, 5, 6 >>>a, 9, 8 >>>a, 1, 9 >>>c, 1, 3 >> >>> I would like

Re: [sqlite] Getting a list of items on a column

"C.Peachment" wrote, On Sat, 5 May 2007 19:58:19 -0400, jose isaias cabrera wrote: Greetings! imagine this data content, c1, c2, c3 a, 1, 2 b, 3, 4 c, 5, 6 a, 9, 8 a, 1, 9 c, 1, 3 I would like to get a list of all the items in c1. So, the return would be, a, b, c I know how

Re: [sqlite] Getting a list of items on a column

On Sat, 5 May 2007 19:58:19 -0400, jose isaias cabrera wrote: >Greetings! >imagine this data content, >c1, c1, c3 >a, 1, 2 >b, 3, 4 >c, 5, 6 >a, 9, 8 >a, 1, 9 >c, 1, 3 >I would like to get a list of all the items in c1. So, the return would be, >a, >b, >c >I know how to do it

[sqlite] Getting a list of items on a column

Greetings! imagine this data content, c1, c1, c3 a, 1, 2 b, 3, 4 c, 5, 6 a, 9, 8 a, 1, 9 c, 1, 3 I would like to get a list of all the items in c1. So, the return would be, a, b, c I know how to do it programmatically, but is there a way to get it right from SQLite? thanks, josé

Re: [sqlite] Re: Powered by SQLite image?

On 5/5/07, A. Pagaltzis <[EMAIL PROTECTED]> wrote: Hi Alberto, Maybe contribute both to SQLite? They'd make excellent additions to the art/ directory in the source tarball. (I'm not sure what it would take for Dr. Hipp to include them?) The xcf file can be downloaded from

[sqlite] Re: Powered by SQLite image?

Hi Alberto, * Alberto Simões <[EMAIL PROTECTED]> [2007-05-04 22:10]: > Ok, I had some time today. What do you think of the one shown > in: http://dicionario-aberto.net/bin/dic.pl excellent! That looks exactly the way I imagined such a button should look. :-) * Alberto Simões <[EMAIL PROTECTED]>

Re: [sqlite] Curious performance issue with large number of inserts

On 5 May 2007, at 17:11, Joe Wilson wrote: What timings do you get when you run the perl script in my last email? I'll try it Tuesday, I'm not back at work till then. - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] Curious performance issue with large number of inserts

--- Tim Bradshaw <[EMAIL PROTECTED]> wrote: > > I can't reproduce your problem. I can insert 16M records into your > > table > > schema in 25 minutes on a 5 year old Windows machine. The sqlite3 > > process > > had peak RAM usage of less than 20M. > > Rats, I suspect it must be some

Re: [sqlite] Curious performance issue with large number of inserts

On 5 May 2007, at 15:59, Joe Wilson wrote: Ignore the idea above - an insert of NULL or an incrementing integer for the INTEGER PRIMARY KEY yields the same timings. I might try taking it out anyway - I don't really need it other than to be able to say "look at row n" to someone. I did

Re: [sqlite] Curious performance issue with large number of inserts

--- Joe Wilson <[EMAIL PROTECTED]> wrote: > > create table filemap(id integer primary key, > >uid integer, gid integer, mtime integer, > >vol integer, > >path varchar(1024)); > > > > It has no indices built yet. > > > > I'm adding quite a lot of records to it using a perl script

Re: [sqlite] Curious performance issue with large number of inserts

> create table filemap(id integer primary key, >uid integer, gid integer, mtime integer, >vol integer, >path varchar(1024)); > > It has no indices built yet. > > I'm adding quite a lot of records to it using a perl script which > generates SQL like this: > > begin; > insert into

Re: [sqlite] how to add a new column quickly

On Sat, May 05, 2007 at 19:30:59 +0800, ronggui wong wrote: > Thanks. But there is no typo, what I want is a general solution. > > 2007/5/5, Tomash Brechko <[EMAIL PROTECTED]>: > >On Sat, May 05, 2007 at 14:01:56 +0800, ronggui wong wrote: > >> . update tablename set newcolname=1 where ROWID=1 >

Re: [sqlite] how to add a new column quickly

Thanks. But there is no typo, what I want is a general solution. 2007/5/5, Tomash Brechko <[EMAIL PROTECTED]>: On Sat, May 05, 2007 at 14:01:56 +0800, ronggui wong wrote: > . update tablename set newcolname=1 where ROWID=1 > . update tablename set newcolname=2 where ROWID=2 > . update tablename

Re: [sqlite] how to add a new column quickly

On Sat, May 05, 2007 at 14:01:56 +0800, ronggui wong wrote: > . update tablename set newcolname=1 where ROWID=1 > . update tablename set newcolname=2 where ROWID=2 > . update tablename set newcolname=2 where ROWID=3 > . > > My question is: how to add the above task efificiently? Thanks! If

[sqlite] how to add a new column quickly

I would like to add a new column to an existing table. I use .alter table tablename add newcolname to add a new col, and use . update tablename set newcolname=1 where ROWID=1 . update tablename set newcolname=2 where ROWID=2 . update tablename set newcolname=2 where ROWID=3 . My question is: