Creating an sqlite database using command line shell in windows

Question

I have my sqlite3.exe file in C:\ and i want to create an sqlite database in C:\db\sqlite.I have tried sqlite3 ex1 as suggested on the docs http://www.sqlite.org/sqlite.html but i get the error Error Near "sqlite3".

What is the correct way of creating a new database from the shell?.

Answer 1

As new file is created in current directory, for creating file at different location you should follow this format:

eg. for storing file FILENAME.db at c:/users/xyz/abc you should type

sqlite>.open c:/users/xyz/abc/FILENAME.db

and then press enter a new file will be created at the mentioned path.

and now when you will type .databases you will see your file listed in the list of databases.