#Sqlite commands list manual#

O All other command line options are processed.ĪUTHORThis manual page was originally written by Andreas Rottmann O If the -init option is present, the specified file is processed. It should generally only contain meta-commands. O The default configuration is established as follows:Ĭan be found in the user's home directory, it is Throughout initialization, any previously Reads an initialization file to set the configuration of the stats Print memory stats before each finalize. nullvalue string Set string used to represent NULL values. separator separator Set output field separator. Scripts or other programs -list Query results will be displayed with the separator (|, by default)Ĭharacter between each field value. line Query results will be displayed with one value per line, rows html Query results will be output as simple HTML tables. csv Set output mode to CSV (comma separated values). Whitespace characters to separate the columns and align theīefore reading stdin. column Query results will be displayed in a table like form, using

, which can contain a mix of SQL statements and meta-commands. Has the following options: -init file Read and execute commands from timeout MS Try opening locked tables for MS milliseconds tables ?PATTERN? List names of tables matching a LIKE pattern show Show the current values for various settings separator STRING Change separator used by output mode and. schema ?TABLE? Show the CREATE statements prompt MAIN CONTINUE Replace the standard prompts nullvalue STRING Print STRING in place of NULL values mode MODE ?TABLE? Set output mode where MODE is one of:Ĭolumn Left-aligned columns. indices TABLE Show names of all indices on TABLE import FILE TABLE Import data from FILE into TABLE header(s) ON|OFF Turn display of headers on or off explain ON|OFF Turn output mode suitable for EXPLAIN on or off. databases List names and files of attached databases Meta-commands areĪ list of available meta-commands can be viewed at any time by issuing Used to control the output format, examine the currently attachedĭatabase files, or perform administrative operations upon theĪttached databases (such as rebuilding indices). The interactive interpreter offers a set of meta-commands that can be Sqlite3 -line mydata.db 'select * from memos where priority > 20 ' Multiple statements should be separated by Optionally, a SQL statement or set of SQL statements can be supplied asĪ single argument. Possibly changing the schema along the way. This is useful for migrating data between databases, ATTACH can alsoīe used to attach to multiple databases within the same interactive To attach to existing or create new database files. If no database name is supplied, the ATTACH sql command can be used Insert into memos values('lunch with Christine', 100) Insert into memos values('deliver project description', 10) If the database fileįor example, to create a new database file named 'mydata.db', createĪ table named 'memos' and insert a couple of records into that table:Ĭreate table memos(text, priority INTEGER) If theĭatabase file does not exist, it will be created. Queries interactively and display the results in multiple formats.Ĭan also be used within shell scripts and other applications to provideĬommand and optionally provide the name of a database file.

Is a terminal-based front-end to the SQLite library that can evaluate A command line interface for SQLite version 3 Command to display sqlite3 manual in Linux: $ man 1 sqlite3 NAME