SQLite Learning Day No. 03: Environment Building

Compared to other databases, SQLite's environment is easy to set up and can be completed in just a few steps:

(1) First, download the precompiled shell binaries from Http://www.sqlite.org/download.html's website, such as "Sqlite-shell-win32-x86-xxx.zip" under the Windows platform. Unzip the package to a local folder, for example, I use "E:\SQLITE\bin", extract it, you can get a separate "sqlite3.exe" file.

(2) To configure the environment variables, it is simple to add the "E:\SQLITE\bin" path to the PATH environment variable.

(3) Open the console in Windows, and then enter "Sqlite3" to enter the SQLite shell, you can do the appropriate database management operations.

Note that there is a very important difference here: SQLite commands are not terminated with semicolons (;), but instead use point commands, where each command begins with a dot (.).

1 View all supported commands

. Help

2 exit

. Quit  or  . Q

3 Creating a Database

Sqlite3 db_name

Of course, you can also create a database under the specified directory:

Sqlite3 e:/db/salary.db

4来 viewing the default settings of the SQLite command prompt

. Show

5 Viewing the list of added databases

. Database

SQLite Learning Day No. 03: Environment Building