Those commands are specific to the sqlite3 command line tool program.
Run sqlite3 from a command line to get them.
José Antonio Gonçalves Motta wrote:
I'm accessing SQLite through a JDBC driver in a java program, but I
get an error everytime I use SQLite line command (like ".output"). Is
it
Regarding: I'm accessing SQLite through a JDBC driver in a java program, but I
get an error everytime I use SQLite line command (like ".output"). Is it
because the driver doesn't understand those commands?"
Commands such as ".output" are not part of sqlite proper. They are part of the
Regarding: "I was wondering if SQLite supports the command SELECT ...
INTO OUTFILE ..."
No, but the sqlite3 command-line utility supports an equivalent:
.output outfile.csv
.select .
.output stdout
You may also want to look at the commands
.separator
.mode
.header
>
> I was wondering if SQLite supports the command
> SELECT ... INTO OUTFILE ...
Can't you accomplish this in the programming language you're using to access
the SQLite database? The SQLite command line utility (
http://www.sqlite.org/sqlite.html) has an option for specifying an output
file.
4 matches
Mail list logo