Search code examples
databasesqlitecommand

How to create a new SQLite database?

I am working on Mac OS X, I want to create a new SQLite DB, and I am using http://www.sqlite.org/quickstart.html as a reference.

I am entering: sqlite3 test.db and getting the response:

SQLite version 3.6.12
Enter ".help" for instructions
Enter SQL statements terminated with a ";"

Why is this happening?

Solution

  • Because that is the administrative shell prompt. The shell created test.db and is now waiting for you to do something with it thus the sqlite> prompt you see.

    You may want to create table ... at this point.