Okay, after all done, this is what I get when I re-launch sqlite:
G4:/applications/sqlite rnagle$ ./sqlite SQLite version 2.8.13 Enter ".help" for instructions sqlite> .databases 0 main 1 temp sqlite>
Where is the test.db ? I just made it, how come its not listed under the .databases command.
thanks Richard
On Apr 18, 2004, at 10:23 AM, Puneet Kishor wrote:
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.h test
G4:/applications/sqlite rnagle$ sqlite test.db
-bash: sqlite: command not found
G4:/applications/sqlite rnagle$ sqlite test.db
-bash: sqlite: command not found
G4:/applications/sqlite rnagle$
as you can see from the terminal prompt, I was in he sqlite directory, and type the command, but could not launch app.
you need to type > ./sqlite test.db
for security reasons, by default, the current directory is not in the path in Unix-based computers.
Perhaps getting a book on learning Unix would be a worthwhile pursuit. I may be incorrect, but it might be possible that you are using a Mac (I am assuming so from your "G4" prompt). There is a new O'Reilly book out on Unix of Mac OS X users (I forget the exact title). Most of their books are really nice, so that will be a really neat investment.
Thanks- Richard
On Apr 18, 2004, at 10:03 AM, Yves Glodt wrote:
-----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: libsqlite.a sqlite sqlite readme.pdf sqlite.h
I been clicking on ssqlite, which is the a unix exe file. and it brings up a terminal window with sqlite,
If you start sqlite by clicking on it, you have no possibility to give a
command-line parameter.
You must open a terminal window, then cd to the place you have sqlite installed, and then type: sqlite test.db
then you will get the prompt as you describe below, with the difference
that a new database called test.db has been created.
running...
sqlite> # this is the prompt I see, now what do I enter in?
e.g. enter sql commands to create tables or query them. See my first reply to have an example
Thanks- Richard
On Apr 18, 2004, at 3:59 AM, Yves Glodt wrote:A new database is created when u call sqlite.exe with a filename as parameter. Of course only if this file does not yet exist... e.g.:
~$ sqlite test.db SQLite version 2.8.13 Enter ".help" for instructions sqlite> create table testtable ( ...> id integer, ...> name varchar(64) ...> ); sqlite> insert into testtable values (1,'Joe'); sqlite> select * from testtable; 1|Joe sqlite>.q ~$
-------------------------------------------------------------------- -
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
- -- Linux 2.4.26 #4 Wed Apr 14 19:23:19 CEST 2004 i686 15:59:29 up 3:27, 1 user, load average: 0.46, 0.42, 0.29 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux)
iD8DBQFAgorMfmxiTOp0sQYRAtxBAJ0XlssCbxMvBVNB505tINyWvhJDGwCeILcz vZJDSwf17qrw+59y7UA1cl4= =DmI0 -----END PGP SIGNATURE-----
--------------------------------------------------------------------- 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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
