Re: [sqlite] how do I select on a field that contains text and digits eg: "chr19:200"

Thank you for everyones help, it was most useful much appreciated ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] how do I select on a field that contains text and digits eg: "chr19:200"

normally if I want to select within a range of numbers I can do something like this: sqlite3 $db "select * from SNPS where $Start >= 1 and $Start <= 10" gives: 1 100 222 1123 1122 etc. how do I do the same select statement where the field are pre-appended with a word and a colon eg

Re: [sqlite] CREATE TABLE work arounds?

Thank You very much for all your responses and suggestions, they provided me with the information I needed to correct the issue. Cheers. ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] CREATE TABLE work arounds?

I am parsing fields on the fly and then creating tables, unfortunately one of the fields is "Order" and is a "special word" in SQL as is not allowed. Is there a way around this instead of intercepting with perl s'/Order/Orders/g' thanks sqlite3 DB "CREATE TABLE META (channel_count TEXT ,

Re: [sqlite] sqlite update with joins

That works... Thank you very much. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite update with joins

I know sqlite update with joins is not supported but I have heard work arounds without the need for scripting. eg: 2 tables H and F both join on FILENAME I want to update h.FILENAME so its the same as the rowid of table F sqlite3 F "update H h , F f set h.FILENAME=f.rowid where

Re: [sqlite] select %column% from table

Thank you all, I am amazed by both the generousity and the intelligent solutions by everyone. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] select %column% from table

unk.k...@gmail.com> wrote: > On Fri, Apr 30, 2010 at 9:28 AM, David Lyon <david_ly...@yahoo.com> wrote: >> If I had a table called TABLE with fields P1N..P50N is there a way to >> select something like: >> >> "select P%N from TABLE" >>

[sqlite] select %column% from table

If I had a table called TABLE with fields P1N..P50N is there a way to select something like: "select P%N from TABLE" to return all the results from columns P1N..P50N or do I have to do it manually: "select P1N, P2N, P3N, P$nN from TABLE" I can obviously do it via scripting but

[sqlite] SQLITE .import

sqlite3 ".import FILE TABLE "; can someone clarify: 1) Can I import into a file into a db table where they are more columns in the db table than in the file to upload? >From my understanding its a no. 2) In this case the ordering of the columns of the table has to be consistent with the

Re: [sqlite] syntax for sqlite to query across 2 databases

te: Sunday, March 14, 2010, 10:35 PM > Perhaps you should start by telling > *all* your sqlite issues. That > would make for more efficient help being provided. See more > below -- > > > On Sun, Mar 14, 2010 at 8:21 PM, David Lyon <david_ly...@yahoo.com> > wrote

Re: [sqlite] syntax for sqlite to query across 2 databases

QLite Database" <sqlite-users@sqlite.org> > Date: Sunday, March 14, 2010, 9:37 PM > On Sun, Mar 14, 2010 at 06:22:15PM > -0700, David Lyon scratched on the wall: > > > Can you or someone provide the exact syntax for ATTACH > > > >   http://www.lmgtfy.com/?

Re: [sqlite] syntax for sqlite to query across 2 databases

m: P Kishor <punk.k...@gmail.com> > Subject: Re: [sqlite] syntax for sqlite to query across 2 databases > To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > Date: Sunday, March 14, 2010, 9:02 PM > On Sun, Mar 14, 2010 at 6:01 PM, > David Lyon

[sqlite] syntax for sqlite to query across 2 databases

if I had a database called db1 with table tbl1 with field id and a second db called db2 and a table called tbl2 with field id, whats the correct syntax to query across the 2 databases eg: "select * db1..tbl1 a , db2..tbl2 b where a.id=b.id" This doesnt work, can someone modify it to work?