sqlit--Learning Tutorial (command)

This time only tests the operation on Windows to see the installation of other versions: Http://www.runoob.com/sqlite/sqlite-installation.html

SqliteCommand

This chapter will explain the simple but useful commands that SQLite programmers use. These commands are called SQLite point commands, which differ in that they do not end with semicolons ;

Let's type a simple sqlite3 command at the command prompt, and you can use various SQLite commands at the SQLite command prompt.

To get a list of available point commands, you can enter ". Help" at any time. For example:

The above command displays a list of the various important SQLite point commands, as follows:

Let's try using the . Show command to see the default settings for the SQLite command prompt.

Make sure there are no spaces between the sqlite> prompt and the point command, otherwise it will not work correctly.

Formatted output

You can use the following point commands to format the output as listed below for this tutorial:

Sqlite_master form

The primary table holds the key information for the database table and names it as sqlite_master. To view a summary of a table, you can do this as follows:

SQLite;.  Schema Sqlite_master 

This will produce the following results:

sqlit--Learning Tutorial (command)