-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Sunday 18 April 2004 08:32, Richard wrote: > 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.
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 ~$ Find more information here: http://www.sqlite.org/sqlite.html enjoy, and best regards, Yves > Thanks- > Rick > > > --------------------------------------------------------------------- > 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 09:52:07 up 8 min, 1 user, load average: 0.08, 0.23, 0.13 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFAgjVffmxiTOp0sQYRAhnpAJ9/fpzyn8/L34dNtaPfLUNENGil2ACeMm0a mWfFhG08tyiZRCQOwHyyoQ0= =NBC6 -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
