On Mon, Nov 30, 2009 at 2:18 PM, <reiser.p...@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.p...@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
