On Sun, Nov 01, 2009 at 10:03:53PM -0500, waltd...@waltdnes.org scratched on
the wall:
> 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?
';' to end the current SQL command.
Recompile with readline support and you'll get history.
> 2) Is there a way to change the output field separator from "|", along
> the lines of the Oracle client "set colsep" command?
.mode
> 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.
Like a shell-script variable? No.
> 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.
$ sqlite3
SQLite version 3.6.18
Enter ".help" for instructions <=== You're missing this.
sqlite>
It isn't "full", but it will tell you most of what you need to know.
-j
-
Jay A. Kreibich < J A Y @ K R E I B I.C H >
"Our opponent is an alien starship packed with atomic bombs. We have
a protractor." "I'll go home and see if I can scrounge up a ruler
and a piece of string." --from Anathem by Neal Stephenson
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
