Re: [sqlite] Create a New Database?

[Richard]

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, running...
sqlite>                       # this is the prompt I see,
now what do I enter in?
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]