Creating an SQLite3 database using Windows

Question

So my terminal which says

sqlite>

and I enter the following text:

sqlite> test.db

The problem is when I press enter, it just gives me:

...>

How come it is not creating the database? I've tried also entering:

sqlite> sqlite3 test.db

But that didn't work either. What is my problem?

AJ X. · Accepted Answer · 2016-11-26 20:39:32Z

1

execute sqlite3 <db_name> from the command line before you have the sqlite3 terminal open.

for example:

C:\> sqlite3 mydb
sqlite> create table table1 (....)

There is additional documentation in the sqlite command line documentation.

answered Nov 26, 2016 at 20:39

AJ X.

2,7701 gold badge25 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

What if I don't have a database created yet? That's why I was trying to make test.db

the first command will create the database mydb for you if it doesn't exist yet.