Am 01.10.2005 um 06:58 schrieb Richard Nagle:
Well,
Did this:
sqlite3 test2.db
create Table T (A, B, C );
.separator ,
.import 'sqtest2.txt' T
It looks like it working, but the file size is still
4K and not 170 Megs.
Please note:
I exported this database as a Tab delimiter file,
then as a Comma, delimiter file...
** Got it to import, however it only imports the first record
ie:
sqlite> select * from T;
-180,90,NaN
sqlite>
There's a few more hundred thousands.....
is there suppose to be some kinda of loop statement
like repeat again..
Are you sure your text file has the correct line-endings? From a
quick look at the shell sources, it looks like the shell expects
native line-endings for the imported file. If the line-endings are
not the native endings, the entire file may be interpreted as a
single line, skipping everything past the first column values...
</jum>
