Geek asks and answers

SQLite error to create database

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 get the error as above. Please, help

-1
source share
1 answer

sqlite3 DatabaseName.db- this is what you would use on the command line, and not when you already started the shell. Running this on the command line will open it in a shell with an already empty base open.

When your invitation sqlite>, you are already in the shell.

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

+11
source

More articles:


All Articles