On Thu, Jul 01, 2010 at 12:22:14PM +0200, Buschhardt, Thomas scratched on the wall: > Error: sqlite3 -separator ";" -csv ... > > The separator will ignored. > > Workaround: sqlite3 -csv -separator ";" ...
For what it is worth, this is the exact same inside the shell: $ ./sqlite3 SQLite version 3.6.23.1 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> CREATE TABLE t ( a, b, c ); sqlite> INSERT INTO t VALUES ( 1, 2, 3 ); sqlite> .separator ; sqlite> SELECT * FROM t; 1;2;3 sqlite> .mode csv sqlite> select * FROM t; 1,2,3 sqlite> Basically, the "mode" operators may set the separator. It wouldn't really be a *C*SV output if it didn't. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
