Hi,
According to the man page, .mode works only for output mode.
.mode MODE ?TABLE? Set output mode where MODE is one of:
csv Comma-separated values
......
However, it seems that it works for .import as well (see my example
below). I'm wondering whether this is the case. If so, should the man
page be revised to make this clearer? Where I should send the request
to revise the man page?
$ cat main.sql
#!/usr/bin/env bash
rm -f main.db
sqlite3 main.db <<EOF
create table test (id integer primary key, value text);
insert into test (value) values('eenie a');
insert into test (value) values('meenie e');
insert into test (value) values('miny');
insert into test (value) values('mo');
.output file.csv
.mode csv
select * from test;
.output stdout
EOF
rm -f main.db
sqlite3 main.db <<EOF
create table test (id integer primary key, value text);
.mode csv
.import file.csv test
.headers on
.mode column
select * from test;
EOF
--
Regards,
Peng
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
