Sqlite3  test.db<<

And if this doesn't seem to work try using the full filepath, eg: Sqlite3 c:\Mydata\test.db.

Otherwise the database will be created in whatever folder your PC currently thinks is its "home" folder.

Most of us newbies end up with databases in mysterious places we only find months after we thought we'd failed to create them!

Michael Hooker


----- Original Message ----- From: "Griggs, Donald" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, August 07, 2007 1:51 PM
Subject: RE: [sqlite] Help Creating database????


Hi Kishore,

Regarding: "  Can you give me the commands to createt 'test.db' database
and to create a sample table in this database? "

Try

Sqlite3  test.db
CREATE TABLE MyTable (a, b, c);
.quit

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to