On Fri, Apr 30, 2010 at 10:17 AM, Gerry Snyder <mesmerizer...@gmail.com> wrote:
> So why not columns keyword and value?
>

because, each row is a conceptual "text file" with many key-value
combos. Putting them in separate rows would mean that each key-val
belongs in a separate text file, whatever that text file represents.
That is not what the OP wants.


> Gerry
>
> On 4/30/10, David Lyon <david_ly...@yahoo.com> wrote:
>> Thanks for everyones efforts let me expand:
>>
>>
>> if I had many many files like this:
>> http://research.stowers-institute.org/efg/ScientificSoftware/Utility/FCSExtract/CC4_067_BM.txt
>>
>> you see 2 columns keyword and value, the keywords would be the fields  (1st
>> column in the html link above) in the table while the values (second column)
>> are the data I would insert.
>>
>> The fields will be many and include
>>
>> P$nR
>> P$nS
>> P$nB
>>
>> etc.
>>
>> thats why I wanted a quick way to access "select P%R from TABLE";
>>
>>
>> thanks again
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> ----- Original Message ----
>> From: P Kishor <punk.k...@gmail.com>
>> To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
>> Sent: Fri, April 30, 2010 10:48:41 AM
>> Subject: Re: [sqlite] select %column% from table
>>
>> crap! I completely misunderstood your question... be confused, and
>> then ignore my reply.
>>
>> On Fri, Apr 30, 2010 at 9:43 AM, P Kishor <punk.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"
>>>>
>>>>  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"
>>>>
>>>
>>> use GLOB. See below
>>>
>>> Last login: Wed Apr 28 09:42:46 on console
>>> punk...@lucknow ~$sqlite3
>>> -- Loading resources from /Users/punkish/.sqliterc
>>> SQLite version 3.6.23
>>> Enter ".help" for instructions
>>> Enter SQL statements terminated with a ";"
>>> sqlite> CREATE TABLE t(a);
>>> sqlite> INSERT INTO t VALUES ('P1N');
>>> sqlite> INSERT INTO t VALUES ('P3N');
>>> sqlite> INSERT INTO t VALUES ('P30N');
>>> sqlite> INSERT INTO t VALUES ('P303N');
>>> sqlite> INSERT INTO t VALUES ('P303X');
>>> sqlite> INSERT INTO t VALUES ('P30Z');
>>> sqlite> SELECT * FROM t;
>>> a
>>> ----------
>>> P1N
>>> P3N
>>> P30N
>>> P303N
>>> P303X
>>> P30Z
>>> sqlite> SELECT * FROM t WHERE a GLOB 'P*N';
>>> a
>>> ----------
>>> P1N
>>> P3N
>>> P30N
>>> P303N
>>> sqlite>
>>>
>>>
>>>> I can obviously do it via scripting but wanted a more elegant way.
>>>>
>>>> Thanks for your help in advance.
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> sqlite-users mailing list
>>>> sqlite-users@sqlite.org
>>>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>>>
>>>
>>>
>>>
>>> --
>>> Puneet Kishor http://www.punkish.org
>>> Carbon Model http://carbonmodel.org
>>> Charter Member, Open Source Geospatial Foundation http://www.osgeo.org
>>> Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor
>>> Nelson Institute, UW-Madison http://www.nelson.wisc.edu
>>> -----------------------------------------------------------------------
>>> Assertions are politics; backing up assertions with evidence is science
>>> =======================================================================
>>>
>>
>>
>>
>> --
>> Puneet Kishor http://www.punkish.org
>> Carbon Model http://carbonmodel.org
>> Charter Member, Open Source Geospatial Foundation http://www.osgeo.org
>> Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor
>> Nelson Institute, UW-Madison http://www.nelson.wisc.edu
>> -----------------------------------------------------------------------
>> Assertions are politics; backing up assertions with evidence is science
>> =======================================================================
>> _______________________________________________
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>>
>>
>>
>> _______________________________________________
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
> --
> Sent from my mobile device
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
Puneet Kishor http://www.punkish.org
Carbon Model http://carbonmodel.org
Charter Member, Open Source Geospatial Foundation http://www.osgeo.org
Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor
Nelson Institute, UW-Madison http://www.nelson.wisc.edu
-----------------------------------------------------------------------
Assertions are politics; backing up assertions with evidence is science
=======================================================================
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to