Syntax error in sqlite trying to create database

Question

I am new to SQLite. I downloaded the latest version of SQLite (both shells and dlls) and extracted them to D: drive. I am executing sqlite3.exe file by double clicking on it.

When I try to create a database using the sqlite3 test.db; I get this error.

D: \ Android Work \ Sqlite \ sqlite-shell-win32-x86-3070800> sqlite3.exe
SQLite Version 3.7.8 2011-09-19 14:49:19
Enter ".help" for instructions
Enter SQL queries terminated by a ";"
sqlite> sqlite3 test.db
...>;
Error: next to "sqlite3": syntax error
sqlite>

Please help me..

Answer 1

I believe that you need to enter "sqlite3 test.db" from the command line, and not inside the SQLite interactive interface.

Look here :

  $ sqlite3 test.db SQLite version 3.0.8 Enter ".help" for instructions sqlite> .quit $