How to create a new SQLite database?

command, database, sqlite

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.

Problem

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?

Original source