One: Install SQLite on Windows
1. Download Please visit the SQLite download page at http://www.sqlite.org/download.html to download the pre-compiled binaries from the Windows area. Need to download sqlite-shell-win32-*.zip and sqlite-dll-win32-*.zip compressed files, here to download sqlite-dll-win32-x86-3080600.zip and sqlite-shell-win32-x86-3080600.zip installation package. The download addresses for the 2 installation packages are as follows: http://www.sqlite.org/2014/sqlite-shell-win32-x86-3080600.zip http://www.sqlite.org/2014/sqlite-dll-win32-x86 -3080600.zip
2, install Create a folder C:\>sqlite, and extract the above two compressed files under this folder, you will get the sqlite3.def, sqlite3.dll and sqlite3.exe files. As shown below: 3, set the environment variables: Win7 system below: In the lower left corner, select the Start menu, right click on the right computer option on the right side of the pop-up, select the Properties menu, select the Advanced System Settings option, then select Advanced, then select the environment variable, Add C:\sqlite at the end of the value in the Path column of the system variable option, click the OK button to save and exit, as shown below: 4. After the operation demonstration is added, use the sqlite3 command in the cmd.exe command line. The operation is as follows: C:\Users\Administrator>sqlite3 ti SQLite version 3.8.6 2014-08-15 11:46:33 Enter ".help" for usage hints. sqlite> create table t1(id int); sqlite> insert into T1 select 1; sqlite> .headers on sqlite> .mode columns sqlite> select * from t1; id ---------- 1 sqlite> sqlite> sqlite> .exit C:\Users\Administrator>, as follows The figure shows:
Two: Install SQLite on Linux
1. Verify that you have the sqlite version. Currently, almost all versions of the Linux operating system come with SQLite. So, just use the following command to check if SQLite is already installed on your machine. [root@name01 sqlite-autoconf-3080600]# sqlite3 SQLite version 3.6.20 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> Already installed, but the sqlite version is not up to date.
2, go to install the latest 3.8.6 version download address: http://www.sqlite.org/2014/sqlite-autoconf-3080600.tar.gz [root@name01 ~]# wget http://www.sqlite .org/2014/sqlite-autoconf-3080600.tar.gz [root@name01 ~]# Start installation [root@name01 ~]# tar -xvf sqlite-autoconf-3080600.tar.gz [root@name01 ~]# cd Sqlite-autoconf-3080600 [root@name01 sqlite-autoconf-3080600]# ./configure --prefix=/usr/local [root@name01 sqlite-autoconf-3080600]# make [root@name01 sqlite-autoconf-3080600]# Make install is installed to see if the latest version has been updated: [root@name01 sqlite-autoconf-3080600]# sqlite3 SQLite version 3.6.20 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .exit [ Root@name01 sqlite-autoconf-3080600]# Manually update sqlite3 to the latest version [root@name01 sqlite-autoconf-3080600]# cp /usr/bin/sqlite3 /usr/bin/sqlite3.bak.3.6.2 [root@ Name01 sqlite-autoconf-3080600]# cp sqlite3 /usr/bin/sqlite3 cp: overwrite `/usr/bin/sqlite3'? y [root@name01 sqlite-autoconf-308 0600]# sqlite3 ti SQLite version 3.8.6 2014-08-15 11:46:33 Enter ".help" for usage hints. sqlite> sqlite> .table sqlite> OK, linux above the default is already the latest 3.8. 6 versions of Sqlite.
Three: Install SQLite on Mac OS X PS: No more installed on Mac OS X, the following is baidu out, you can learn from it.
1, download The latest version of Mac OS X will pre-install SQLite, but if there is no installation available, just follow the steps below: Go to install the latest 3.8.6 version, and the same version of linux sqlite3 installation. The software address is: http://www.sqlite.org/2014/sqlite-autoconf-3080600.tar.gz Start downloading and installing $wget http://www.sqlite.org/2014/sqlite-autoconf-3080600.tar. Gz
2, install $tar xvfz sqlite-autoconf-3080600.tar.gz $cd sqlite-autoconf-3080600 $./configure --prefix=/usr/local $make $make install
3. Log in to sqlite to verify that the above steps will install SQLite on a Mac OS X machine. You can use the following command to verify: $sqlite3 SQLite version 3.8.6 2014-08-11 11:46:33 Enter ".help" for usage hints . sqlite> After the Sqlite3 command prompt, Sqlite3 operation.
SQLite installation process on Windows, Linux, and Mac OS X
