Luc Charansonney wrote:
> sqlite> .separator tabs
sqlite> select 1, 2;
1tabs2
> sqlite> .import mydata.txt mytable
> Error: multi-character column separators not allowed for import
You should have used ".separator \t".
> So I fall back on my feet by using .mode instead of .separator:
> sqli
Hello,
I apologize if the question has already been asked before, but I need some
clarification on the use of .mode and .separator relatively to the .import
command.
Say I have a structured tab-separated text file "mydata.txt" I want to import
into a database using the .import FILE TABLE comma
2 matches
Mail list logo