On Fri, Jan 16, 2009 at 09:43:36AM +0100, Christophe Leske wrote:
> sqlite> .o cl1.sql
^^^^^^^^^^
This says: send output of queries to a file called "cl1.sql".
> sqlite> .dump cl1%
And this says: dump the named table.
> sqlite> select * from cl1;
And the output of this will still go to a file called "cl1.sql".
> sqlite>
>
> Also, a .show statement returns nothing either. It seems as if the
> database does simply not exist anymore.
Look:
% sqlite3 /tmp/xdb
SQLite version 3.6.9
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table t(a);
sqlite> insert into t values (1);
sqlite> .o /tmp/xyz
sqlite> .dump t
sqlite> select * from t;
sqlite> .show
sqlite> .o stdout
sqlite> select * from t;
1
sqlite> .dump t
BEGIN TRANSACTION;
CREATE TABLE t(a);
INSERT INTO "t" VALUES(1);
COMMIT;
sqlite> .show
echo: off
explain: off
headers: off
mode: list
nullvalue: ""
output: stdout
separator: "|"
width:
sqlite> ^D
% sqlite3 /tmp/xdb
SQLite version 3.6.9
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .dump t
BEGIN TRANSACTION;
CREATE TABLE t(a);
INSERT INTO "t" VALUES(1);
COMMIT;
sqlite> ^D
%
Nico
--
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
