>sqlite> .mode csv consult_facts
>Error: invalid arguments: "consult_facts". Enter ".help" for help
.help says, inter alia:
.mode MODE ?TABLE? Set output mode where MODE is one of:
csv Comma-separated values
column Left-aligned columns. (See .width)
html HTML <table> code
insert SQL insert statements for TABLE
line One value per line
list Values delimited by .separator string
tabs Tab-separated values
as explained at http://www.sqlite.org/cli.html
The table name parameter is only required for .mode insert where it specifies
the string to be used for table in the constructed insert into statements:
sqlite> create table x(a,b);
sqlite> insert into x values (1,1), (2,2);
sqlite> .mode insert
sqlite> select * from x;
INSERT INTO table VALUES(1,1);
INSERT INTO table VALUES(2,2);
sqlite> .mode insert AbraCadAbra
sqlite> select * from x;
INSERT INTO AbraCadAbra VALUES(1,1);
INSERT INTO AbraCadAbra VALUES(2,2);
sqlite>
For all other formats the extraneous characters have no effect. Perhaps the
difference is that one version of the sqlite shell silently ignores the
meaningless extra parameter, but the other is not silent and lets you know that
you have made an error.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
