SQLite database Download installation and initial operation and problems encountered near "Sqlite3": syntax error

1. Download the SQLite database:http://www.sqlite.org/download.html

     < Span style= "font-size:14px" > If you are installing on a window you need to be in the  windows Zone to download the precompiled binaries. Download download   Sqlite-shell-win32-*.zip   and   sqlite-dll-win32-*.zip   compressed files.

2. Download and unzip   and   sqlite-dll-win32-*.zip sqlite3.def , Sqlite3.dll, and Sqlite3.exe files.

        can put them anywhere on my computer, where I put these three files in  c:\>sqlite (that is, a SQLite folder was built in the C drive)

add C:\>sqlite to the PATH environment variable, and finally at the command prompt (cmd command), using the Sqlite3 command, the following results are displayed.

Input. Help:

The SQLite database is installed successfully.

3. Problems encountered

If you build a database directly inside SQLite, the following situation will occur: near "sqlite3": syntax error

this happens because SQLite already represents the database and how it is in the database inside wearer database. If you want to create a database, you can do this: create it directly in the C drive.

Of course, you can also create in the D, F disk:

SQLite database Download installation and initial operation and problems encountered near "Sqlite3": syntax error