Richard Nagle wrote:
Sorry, let me get this straight: WHAT syntax command do I use ?
sqlite> Make new database ? sqlite>contacts;
The problem there is no Contacts database created ? I would have to make a database first, before creating tables? please explain.....
You don't make the database explicitly. You give the name of the database on the commandline, before you enter the sqlite command shell:
$ pwd
/projects/test
$ sqlite contacts
SQLite version 2.8.15
Enter ".help" for instructions
sqlite> .database
seq name file
--- --------------- ----------------------------------------------------------
0 main /projects/test/contacts
1 temp /var/tmp/sqlite_ZFSmuMGwKY4qVLY
This is the same in SQLite 3.
HTH
Ulrik P.
-- Ulrik Petersen, MA, B.Sc. University of Aalborg, Denmark
