[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] Getting up and running
From:       P Kishor <punk.kish () gmail ! com>
Date:       2009-11-30 20:53:43
Message-ID: cdf6db500911301253g227def75oe5c890df6b3f7f50 () mail ! gmail ! com
[Download RAW message or body]

On Mon, Nov 30, 2009 at 2:18 PM,  <reiser.paul@gmail.com> wrote:
> 
> Hi - thanks for the help. Eventually I will want to get more involved, but this \
> lets me learn sql on my own database which is really helpful. One problem I am \
> having is that I have a tab-delimited text file which I load using the commands: 
> > CREATE TABLE test(a, b, c, d);
> > .mode tabs
> > .import "tab_delimited_data.txt" test
> > .mode column
> > SELECT d FROM test where d LIKE '%hello%'
> 
> the resulting strings are just the first 16 characters. Can you tell me how to get \
> the whole string? 

If using .mode col, see
sqlite> .width NUM

also

sqlite> .help

Finally, please reply/ask questions on the list instead of directly,
so others also have a chance to answer/learn.

Good luck with sqlite.



> 
> 
> 
> 
> 
> P Kishor-3 wrote:
> > 
> > On Mon, Nov 30, 2009 at 8:09 AM, FrankLane <reiser.paul@gmail.com> wrote:
> > > 
> > > Hi - I downloaded sqlite-amalgamation-3_6_20.zip and now I have a folder
> > > with
> > > three files: sqlite3.c, sqlite3.h, and sqlite3ext.h. I have no idea what
> > > to
> > > do next. I have a Mac 2.4 GHz Intel Core 2 Duo running Mac OS X 10.6.1.
> > > Can
> > > anyone guide me to a page that steps me through an installation process?
> > 
> > 
> > What you should do next depends on what you want to do next. Do you
> > want to just use the sqlite database from the command line as is? In
> > that case, do what Simon told you in a different email, that is, use
> > the sqlite version that comes with the operating system. You can find
> > it at /usr/bin/sqlite3 and its header files under /usr/include
> > 
> > If you want to tinker with the sqlite source code, tweak the compile
> > time settings, or just want the latest version, then, make sure you
> > have the developer tools installed (Xcode), then go into your folder
> > that you downloaded above and type
> > 
> > sqlite-src % ./configure
> > sqlite-src % make
> > sqlite-src % sudo make install
> > 
> > The above three commands will build a new version of sqlite and
> > install it under /usr/local/
> > 
> > Then, make sure that /usr/local/bin comes before /usr/bin in your
> > search path and fire up /usr/local/bin/sqlite3 and have fun.
> > 
> > 
> > 
> > --
> > 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
> > =======================================================================
> > Sent from Madison, WI, United States
> > _______________________________________________
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> > 
> > 
> Quoted from:
> http://old.nabble.com/Getting-up-and-running-tp26575335p26579871.html
> 
> 



-- 
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
=======================================================================
Sent from Madison, WI, United States
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[prev in list] [next in list] [prev in thread] [next in thread]