Subj : Re: Database program to just work with text files?
To   : comp.os.linux
From : adams_forum
Date : Mon Aug 30 2004 08:36 pm

> The ".import" command is for version 3.0 only.  For tab-separated
> values, you would do this:
> 
>     .separator \t
>     .import  filename.txt  tabletoimportinto
> 
> You can specify any other separator you want, of course.

Thanks for your help.  I got it imported.

I may not use sqlite after all because I discovered one major problem
with it: it prints columns in a fixed way.  In other words, if you
want your data to appear in columns, you have to set the width of each
column appropriately - but this width varies based on the columns I've
selected in my "select" statement.  mysql automatically figures out
how wide to make the columns based on the maximum width of the data. 
It's too bad, too, because everything else about sqlite was just what
I was looking for.

.