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