| OLD | NEW |
|---|
| (Empty) |
| 1 .\" Hey, EMACS: -*- nroff -*- | |
| 2 .\" First parameter, NAME, should be all caps | |
| 3 .\" Second parameter, SECTION, should be 1-8, maybe w/ subsection | |
| 4 .\" other parameters are allowed: see man(7), man(1) | |
| 5 .TH SQLITE3 1 "Mon Apr 15 23:49:17 2002" | |
| 6 .\" Please adjust this date whenever revising the manpage. | |
| 7 .\" | |
| 8 .\" Some roff macros, for reference: | |
| 9 .\" .nh disable hyphenation | |
| 10 .\" .hy enable hyphenation | |
| 11 .\" .ad l left justify | |
| 12 .\" .ad b justify to both left and right margins | |
| 13 .\" .nf disable filling | |
| 14 .\" .fi enable filling | |
| 15 .\" .br insert line break | |
| 16 .\" .sp <n> insert n+1 empty lines | |
| 17 .\" for manpage-specific macros, see man(7) | |
| 18 .SH NAME | |
| 19 .B sqlite3 | |
| 20 \- A command line interface for SQLite version 3 | |
| 21 | |
| 22 .SH SYNOPSIS | |
| 23 .B sqlite3 | |
| 24 .RI [ options ] | |
| 25 .RI [ databasefile ] | |
| 26 .RI [ SQL ] | |
| 27 | |
| 28 .SH SUMMARY | |
| 29 .PP | |
| 30 .B sqlite3 | |
| 31 is a terminal-based front-end to the SQLite library that can evaluate | |
| 32 queries interactively and display the results in multiple formats. | |
| 33 .B sqlite3 | |
| 34 can also be used within shell scripts and other applications to provide | |
| 35 batch processing features. | |
| 36 | |
| 37 .SH DESCRIPTION | |
| 38 To start a | |
| 39 .B sqlite3 | |
| 40 interactive session, invoke the | |
| 41 .B sqlite3 | |
| 42 command and optionally provide the name of a database file. If the | |
| 43 database file does not exist, it will be created. If the database file | |
| 44 does exist, it will be opened. | |
| 45 | |
| 46 For example, to create a new database file named "mydata.db", create | |
| 47 a table named "memos" and insert a couple of records into that table: | |
| 48 .sp | |
| 49 $ | |
| 50 .B sqlite3 mydata.db | |
| 51 .br | |
| 52 SQLite version 3.1.3 | |
| 53 .br | |
| 54 Enter ".help" for instructions | |
| 55 .br | |
| 56 sqlite> | |
| 57 .B create table memos(text, priority INTEGER); | |
| 58 .br | |
| 59 sqlite> | |
| 60 .B insert into memos values('deliver project description', 10); | |
| 61 .br | |
| 62 sqlite> | |
| 63 .B insert into memos values('lunch with Christine', 100); | |
| 64 .br | |
| 65 sqlite> | |
| 66 .B select * from memos; | |
| 67 .br | |
| 68 deliver project description|10 | |
| 69 .br | |
| 70 lunch with Christine|100 | |
| 71 .br | |
| 72 sqlite> | |
| 73 .sp | |
| 74 | |
| 75 If no database name is supplied, the ATTACH sql command can be used | |
| 76 to attach to existing or create new database files. ATTACH can also | |
| 77 be used to attach to multiple databases within the same interactive | |
| 78 session. This is useful for migrating data between databases, | |
| 79 possibly changing the schema along the way. | |
| 80 | |
| 81 Optionally, a SQL statement or set of SQL statements can be supplied as | |
| 82 a single argument. Multiple statements should be separated by | |
| 83 semi-colons. | |
| 84 | |
| 85 For example: | |
| 86 .sp | |
| 87 $ | |
| 88 .B sqlite3 -line mydata.db 'select * from memos where priority > 20;' | |
| 89 .br | |
| 90 text = lunch with Christine | |
| 91 .br | |
| 92 priority = 100 | |
| 93 .br | |
| 94 .sp | |
| 95 | |
| 96 .SS SQLITE META-COMMANDS | |
| 97 .PP | |
| 98 The interactive interpreter offers a set of meta-commands that can be | |
| 99 used to control the output format, examine the currently attached | |
| 100 database files, or perform administrative operations upon the | |
| 101 attached databases (such as rebuilding indices). Meta-commands are | |
| 102 always prefixed with a dot (.). | |
| 103 | |
| 104 A list of available meta-commands can be viewed at any time by issuing | |
| 105 the '.help' command. For example: | |
| 106 .sp | |
| 107 sqlite> | |
| 108 .B .help | |
| 109 .nf | |
| 110 .cc | | |
| 111 .databases List names and files of attached databases | |
| 112 .dump ?TABLE? ... Dump the database in an SQL text format | |
| 113 .echo ON|OFF Turn command echo on or off | |
| 114 .exit Exit this program | |
| 115 .explain ON|OFF Turn output mode suitable for EXPLAIN on or off. | |
| 116 .header(s) ON|OFF Turn display of headers on or off | |
| 117 .help Show this message | |
| 118 .import FILE TABLE Import data from FILE into TABLE | |
| 119 .indices TABLE Show names of all indices on TABLE | |
| 120 .mode MODE ?TABLE? Set output mode where MODE is one of: | |
| 121 csv Comma-separated values | |
| 122 column Left-aligned columns. (See .width) | |
| 123 html HTML <table> code | |
| 124 insert SQL insert statements for TABLE | |
| 125 line One value per line | |
| 126 list Values delimited by .separator string | |
| 127 tabs Tab-separated values | |
| 128 tcl TCL list elements | |
| 129 .nullvalue STRING Print STRING in place of NULL values | |
| 130 .output FILENAME Send output to FILENAME | |
| 131 .output stdout Send output to the screen | |
| 132 .prompt MAIN CONTINUE Replace the standard prompts | |
| 133 .quit Exit this program | |
| 134 .read FILENAME Execute SQL in FILENAME | |
| 135 .schema ?TABLE? Show the CREATE statements | |
| 136 .separator STRING Change separator used by output mode and .import | |
| 137 .show Show the current values for various settings | |
| 138 .tables ?PATTERN? List names of tables matching a LIKE pattern | |
| 139 .timeout MS Try opening locked tables for MS milliseconds | |
| 140 .width NUM NUM ... Set column widths for "column" mode | |
| 141 sqlite> | |
| 142 |cc . | |
| 143 .sp | |
| 144 .fi | |
| 145 | |
| 146 .SH OPTIONS | |
| 147 .B sqlite3 | |
| 148 has the following options: | |
| 149 .TP | |
| 150 .BI \-init\ file | |
| 151 Read and execute commands from | |
| 152 .I file | |
| 153 , which can contain a mix of SQL statements and meta-commands. | |
| 154 .TP | |
| 155 .B \-echo | |
| 156 Print commands before execution. | |
| 157 .TP | |
| 158 .B \-[no]header | |
| 159 Turn headers on or off. | |
| 160 .TP | |
| 161 .B \-column | |
| 162 Query results will be displayed in a table like form, using | |
| 163 whitespace characters to separate the columns and align the | |
| 164 output. | |
| 165 .TP | |
| 166 .B \-html | |
| 167 Query results will be output as simple HTML tables. | |
| 168 .TP | |
| 169 .B \-line | |
| 170 Query results will be displayed with one value per line, rows | |
| 171 separated by a blank line. Designed to be easily parsed by | |
| 172 scripts or other programs | |
| 173 .TP | |
| 174 .B \-list | |
| 175 Query results will be displayed with the separator (|, by default) | |
| 176 character between each field value. The default. | |
| 177 .TP | |
| 178 .BI \-separator\ separator | |
| 179 Set output field separator. Default is '|'. | |
| 180 .TP | |
| 181 .BI \-nullvalue\ string | |
| 182 Set string used to represent NULL values. Default is '' | |
| 183 (empty string). | |
| 184 .TP | |
| 185 .B \-version | |
| 186 Show SQLite version. | |
| 187 .TP | |
| 188 .B \-help | |
| 189 Show help on options and exit. | |
| 190 | |
| 191 | |
| 192 .SH INIT FILE | |
| 193 .B sqlite3 | |
| 194 reads an initialization file to set the configuration of the | |
| 195 interactive environment. Throughout initialization, any previously | |
| 196 specified setting can be overridden. The sequence of initialization is | |
| 197 as follows: | |
| 198 | |
| 199 o The default configuration is established as follows: | |
| 200 | |
| 201 .sp | |
| 202 .nf | |
| 203 .cc | | |
| 204 mode = LIST | |
| 205 separator = "|" | |
| 206 main prompt = "sqlite> " | |
| 207 continue prompt = " ...> " | |
| 208 |cc . | |
| 209 .sp | |
| 210 .fi | |
| 211 | |
| 212 o If the file | |
| 213 .B ~/.sqliterc | |
| 214 exists, it is processed first. | |
| 215 can be found in the user's home directory, it is | |
| 216 read and processed. It should generally only contain meta-commands. | |
| 217 | |
| 218 o If the -init option is present, the specified file is processed. | |
| 219 | |
| 220 o All other command line options are processed. | |
| 221 | |
| 222 .SH SEE ALSO | |
| 223 http://www.sqlite.org/ | |
| 224 .br | |
| 225 The sqlite-doc package | |
| 226 .SH AUTHOR | |
| 227 This manual page was originally written by Andreas Rottmann | |
| 228 <rotty@debian.org>, for the Debian GNU/Linux system (but may be used | |
| 229 by others). It was subsequently revised by Bill Bumgarner <bbum@mac.com>. | |
| OLD | NEW |
|---|
Chromium Code Reviews
Issue 3108030:
Move bundled copy of sqlite one level deeper to better separate it... (Closed)
Base URL: svn://svn.chromium.org/chrome/trunk/src/