Re: [sqlite] Create a New Database?

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.. please note: using Mac OS X Thanks Richard On Apr 18, 2004, at

Re: [sqlite] Create a New Database?

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

Re: [sqlite] Create a New Database?

Confused, I thought that .databases command would list all database, under sqlite? the you can choose which one you wanted to make active. ??? Once I start sqlite correctly, via the ./sqlite command Now all commands should be active, hence where the database "test.db" I can see it inside the

Re: [sqlite] Create a New Database?

Richard wrote: G4:/applications/sqlite rnagle$ sqlite test.db -bash: sqlite: command not found Hehe, take it you're new to OSX (I think) unix like intricacicies. Should you not type: ./sqlite test.db as you've probably got a setting somewhere to search system paths for binaries not including the

Re: [sqlite] Create a New Database?

On Apr 18, 2004, at 9:15 AM, Richard wrote: Well, I may of have spoken too, soon. G4:/applications/sqlite rnagle$ ls SQLite ReadMe.pdf libsqlite.a sqlite sqlite.htest G4:/applications/sqlite rnagle$ sqlite test.db -bash: sqlite: command not

Re: [sqlite] Create a New Database?

On Apr 18, 2004, at 8:56 AM, Richard wrote: I think, the problem is that, I did do that, sqlite test.db and did not get a correct reply... Hence, wondering if I'm did right.. Inside the SQLITE folder, is the following: libsqlite.a sqlite sqlite readme.pdf sqlite.h

Re: [sqlite] Create a New Database?

Well, I may of have spoken too, soon. G4:/applications/sqlite rnagle$ ls SQLite ReadMe.pdf libsqlite.a sqlite sqlite.htest G4:/applications/sqlite rnagle$ sqlite test.db -bash: sqlite: command not found G4:/applications/sqlite rnagle$ sqlite

Re: [sqlite] Create a New Database?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sunday 18 April 2004 15:56, Richard wrote: > I think, > the problem is that, I did do that, > sqlite test.db > and did not get a correct reply... > > Hence, wondering if I'm did right.. > > Inside the SQLITE folder, is the following: >

Re: [sqlite] Create a New Database?

I think, the problem is that, I did do that, sqlite test.db and did not get a correct reply... Hence, wondering if I'm did right.. Inside the SQLITE folder, is the following: libsqlite.a sqlite sqlite readme.pdf sqlite.h I been clicking on ssqlite, which is the a

[sqlite] Create a New Database?

Okay, Newbie... When into SQlite folder, and click on terminal window app, and launch program... did a .database, shows 0 main 1 temp How does one create a new database...? tried: Create database contact; nope. Thanks- Rick - To