wonderful question, it is also what i'd like to know.
On Thu, Dec 31, 2009 at 1:03 PM, Simon Slavin slav...@bigfraud.org wrote:
On 31 Dec 2009, at 4:56pm, Kees Nuyt wrote:
On Thu, 31 Dec 2009 04:24:51 +, Simon Slavin
slav...@bigfraud.org wrote:
On 31 Dec 2009, at 2:13am, Wensui Liu
Depending on how you are calling sqlite3, you should be able to feed any
list of commands into it.
For example, under a typical Unix shell you could do
sqlite3 mydb EOF
.mode csv
.show
EOF
Here, in fact, is what happens when I type just that
/var/www/canal$ sqlite3 mydb EOF
.mode csv
.show
On Thu, 31 Dec 2009 04:24:51 +, Simon Slavin
slav...@bigfraud.org wrote:
On 31 Dec 2009, at 2:13am, Wensui Liu wrote:
i am trying to change the output by 'sqlite3 mydb .mode csv'.
however, when i type 'sqlite3 mydb .show', I couldn't see the change
of mode at all.
Each new 'sqlite3'
On 31 Dec 2009, at 4:56pm, Kees Nuyt wrote:
On Thu, 31 Dec 2009 04:24:51 +, Simon Slavin
slav...@bigfraud.org wrote:
On 31 Dec 2009, at 2:13am, Wensui Liu wrote:
i am trying to change the output by 'sqlite3 mydb .mode csv'.
however, when i type 'sqlite3 mydb .show', I couldn't see
dear listers,
i am trying to change the output by 'sqlite3 mydb .mode csv'.
however, when i type 'sqlite3 mydb .show', I couldn't see the change
of mode at all.
i appreciate it if anyone can point me to a right direction.
thanks and happy new year!
wensui
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
It definitely changes for me as shown below. If you want further help then
you need to show the exact commands you are running and their output.
$ sqlite3 mydb
SQLite version 3.6.16
Enter .help for instructions
Enter SQL statements terminated with a
On 31 Dec 2009, at 2:13am, Wensui Liu wrote:
i am trying to change the output by 'sqlite3 mydb .mode csv'.
however, when i type 'sqlite3 mydb .show', I couldn't see the change
of mode at all.
Each new 'sqlite3' command starts a new instance of the application, and the
new instance starts