On Apr 18, 2004, at 12:25 PM, Richard wrote:
Hmm, in mysql its not so.... ok,
So, if I move the test.db database, into a another folder called db
Then start sqlite ./sqlite
and do this: .database /db/ this should show the databases in the db folder? or did I miss something..
Richard,
It doesn't matter how it is in MySQL. This is SQLite, and this is how it is...
assuming test.db is in the same folder as sqlite,
> ./sqlite test.db . your other commands... ;
assuming test.db is in a different folder, lets say, a folder called "db", which is not the same as sqlite's folder, you can do...
db> sqlite test.db . your other commands... ;
see what happened above... You didn't type ./sqlite test.db in this second scenario because sqlite is in a different folder while you are in the db folder. The reason it worked is because the folder where sqlite is installed is in the PATH variable. It would be if you installed SQlite correctly. If it isn't, then you need to find out a good place to put sqlite and its libraries somewhere in your path.
You have to specify the database on the same line as the sqlite command > sqlite nameofdatabase
or
> ./sqlite nameofdatabase
It can't be any simpler. Just grab a basic Unix book and you will get much further faster than our fragmented help on this list. Then, do ask SQLite-specific questions here and you will get quick, relevant help.
On Apr 18, 2004, at 10:53 AM, Will Leshner wrote:
On Apr 18, 2004, at 7:42 AM, Richard wrote:
Now all commands should be active, hence where the database "test.db" I can see it inside the folder, but sqlite can not see it, or is there another step I'm missing.
It doesn't work that way. The sqlite command-line tool doesn't look for databases in the same "folder" as it. In fact, if you've installed it correctly, then sqlite becomes a command-line command you can enter anywhere. To examine a sqlite database with the tool, you have to pass the name/path of the database when you invoke it.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
