Hello all;
I'm a bit rusty at SQL, but my newbiness at SQLite is my current
problem. I'm testing stuff manually at the sqlite3 commandline and
adding it to a script which I want to pipe to sqlite3. My questions...
1) An Oracle client habit of mine is to hit up-arrow for commandline
history. On my linux machine (Gentoo 32 bit, Dell Core Duo) doing that
throws sqlite3 out of its mind. It gives me a "...>" prompt. Nothing
seems to work, except {CTRL-D} which shuts down sqlite3. Is there a way
to recover without shutting down sqlite3?
2) Is there a way to change the output field separator from "|", along
the lines of the Oracle client "set colsep" command?
3) Is there a way to define a variable for use at the sqlite3
commandline? Right now I'm faking it by setting up a dummy table with
one row, and then doing a join on that table with the rows where I want
to use that value. It works, but it's painful.
4) And to stop the flow of questions, is there a full manual for sqlite3
somewhere? Whilst looking through Google, I stumbled across the
".database" command, which I do not recall seeing on the sqlite.org web
site documentation. I wonder what else I'm missing.
--
Walter Dnes <[email protected]>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
