CODEWITHSUNDEEP
sqlsqliteshellterminalcommand
James Mitchell
James Mitchell

Reputation: 2467

Creating an SQLite3 database using Windows

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?

Upvotes: 0

Views: 1851

Answers (1)

AJ X.
AJ X.

Reputation: 2770

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.

Upvotes: 1

Related Questions