SQLite error for creating database

Question

SQLite version 3.8.0.2 2013-09-03 17:11:13
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> $sqlite3 DatabaseName.db;
Error: near "$sqlite3": syntax error
sqlite> DatabaseName.db;
Error: near "DatabaseName": syntax error
sqlite> sqlite3 DatabaseName.db;
Error: near "sqlite3": syntax error
sqlite>

I am trying to create a database in SQLite. I am getting the error as above. Please help

sorry I tagged android by mistake. I am writing this in SQLite shell — Abhijeet Limaye, Sep 19 '13 at 10:29
@CL.: I've extracted sqlite3.dll, sqlite3.DEF and sqlite3.exe in one folder. Launching the .exe file — Abhijeet Limaye, Sep 19 '13 at 13:55

Tom Kerr · Answer 1 · 2013-09-19T19:01:37.667

13

sqlite3 DatabaseName.db is what you'd use at the command line, not once you've already started the shell. Running that at command line will open it in the shell with the empty database already open.

When your prompt is sqlite>, you're already in the shell.

Here are some docs: http://sqlite.org/sqlite.html

edited Sep 19 '13 at 19:01

answered Sep 19 '13 at 14:51

Tom Kerr

10,444
2
30
46

SQLite error for creating database

1 Answers1

Linked