Use SQLite command line tool to access database files

Source: Internet
Author: User

Shell of sqlite3 (1)

Sqlite3.exe is a tool for SQLite to access the database, in the form of command lines.
There are two types of shell commands. The first is the shell command, which starts with a point. The second is the SQL command used to manage the current database, ending with a semicolon.
Shell commands are divided into the following types: control data display mode; Set shell to read and display data; other system control commands

Common Display Mode Control commands:
. Header on | off: Specifies whether to display the column name of the data table.
. Indices table: displays all column names in the table.
. Mode mode: Set the display mode of the data table. The default value is list, and the string set by the. Separator command is used to separate characters (the default value is | ). We prefer the column format.
. Nullvalue string: string is used to fill the data with null values. The default value is an empty string, that is, nothing is displayed.
. Tables pattern: displays tables in pattern.
. Width num...: Set the data display width when it is displayed in column mode.

. Output Filename | stdout: Set the form of data output: standard output of a file or screen.
. Read filename: Read the SQL statement from the file

Other System Control commands:
. Databases: displays the currently matched database names
. Table: displays all tables in the current database.
. Help: displays shell help information.
. Show: display the current shell setting parameters
. Quit and. Exit: Exit Shell

Reference: http://www.sqlite.org/sqlite.html

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.