Simon Slavin wrote, On 1/16/2012 1:45 PM:
On 16 Jan 2012, at 7:34pm, Bill McCormick wrote:
Looks like pipes work as well (cat yoursql.sql|sqlite3 yourdb.db3).
Also, can I safely delete the database file (yourdb.db3, using your example) if
I just want to start again? It appears that I can.
Not while an app has it open, but if none of the apps are running then yes: a
database file is just a single file, with no funny tricks about it, and you can
move, rename or delete it.
Where are these little nuggets documented?
www.sqlite.org
I was sort of hoping it might be narrowed down to one of the documents
on this page:
http://www.sqlite.org/docs.html
Typing "script" and "command line" in the search box didn't help me find
what I was looking for either. Worse, it lead me down the Tcl path,
thinking that Tcl would be the only way to do this. I didn't find
anything in the FAQ's that answered my question either.
I guess it's just a matter of coming up to speed.
Thanks!!
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
