Dennis
At 11:01 04/02/2008 -0700, Dennis Cote wrote:
>You will need to do your import in two steps. First import into a temp
>table without the integer primary key column.
Thanks a bunch for the explanation and the how-to. The accented characters
are displayed funny when SELECTed in the DOS com
Gilles wrote:
> At 22:47 04/02/2008 +1100, John Machin wrote:
>
>> Well, obviously(?) you are closer to success with "\t" than with '\t'.
>> You probably have an extra unseen TAB. It won't like that NULL.
>>
>
> Thanks, but no matter what I try, it doesn't work:
> - just two columns, assu
Gilles wrote:
> At 22:47 04/02/2008 +1100, John Machin wrote:
>> Well, obviously(?) you are closer to success with "\t" than with '\t'.
>> You probably have an extra unseen TAB. It won't like that NULL.
>
> Thanks, but no matter what I try, it doesn't work:
> - just two columns, assuming it will
At 22:47 04/02/2008 +1100, John Machin wrote:
>Well, obviously(?) you are closer to success with "\t" than with '\t'.
>You probably have an extra unseen TAB. It won't like that NULL.
Thanks, but no matter what I try, it doesn't work:
- just two columns, assuming it will just increment the primar
Gilles wrote:
> At 02:27 04/02/2008 +0100, Gilles wrote:
>
>> Thanks for the tip, but I tried that too, with no success:
>>
>
> I tried both:
>
> sqlite> .separator "\t"
> sqlite> .import test.csv customer
> test.csv line 1: expected 3 columns of data but found 4
>
> sqlite> .separator '\t'
At 02:27 04/02/2008 +0100, Gilles wrote:
>Thanks for the tip, but I tried that too, with no success:
I tried both:
sqlite> .separator "\t"
sqlite> .import test.csv customer
test.csv line 1: expected 3 columns of data but found 4
sqlite> .separator '\t'
sqlite> .import test.csv customer
test.csv
At 23:42 03/02/2008 +, Robert Wishlaw wrote:
>Instead of
>
>.separator "\t"
>
>try
>
>.separator '\t'
Thanks for the tip, but I tried that too, with no success:
# cat test.csv
NULL123-4567John Doe
(Note: I just replaced 09 with to show you)
# sqlite3 db.sqlite
SQLite version 3.5.4
Enter ".h
7 matches
Mail list logo