On Thu, 12 Jul 2007, Joe Wilson wrote:
The sqlite3 commandline shell has always defaulted to '|' for the
separator. You may have been using .mode csv which changes the separator
before returning to .mode list:
Joe,
Ah, yes. I was exporting rows from tables with mode insert, then reverting
t
The sqlite3 commandline shell has always defaulted to '|' for the
separator. You may have been using .mode csv which changes the
separator before returning to .mode list:
SQLite version 3.4.0
Enter ".help" for instructions
sqlite> .mode list
sqlite> select 1,2,3;
1|2|3
sqlite> .mode csv
sqlite>
Yesterday as I worked on a project database's tables in the SQLite editor,
I saw that the separator was a comma, ",", and thought the default separator
must have changed between versions 3.3.x and 3.4.0. But, when I select data
from the same tables, the separator is back to being the vertical ba
3 matches
Mail list logo
