Index: third_party/sqlite/src/sqlite3.1 |
diff --git a/third_party/sqlite/src/sqlite3.1 b/third_party/sqlite/src/sqlite3.1 |
index 02df7f44c7528e99bd139f7e8c10d0ef829f833b..80353b0eecd9848204c711d6264ca116b2d1064b 100644 |
--- a/third_party/sqlite/src/sqlite3.1 |
+++ b/third_party/sqlite/src/sqlite3.1 |
@@ -2,7 +2,7 @@ |
.\" First parameter, NAME, should be all caps |
.\" Second parameter, SECTION, should be 1-8, maybe w/ subsection |
.\" other parameters are allowed: see man(7), man(1) |
-.TH SQLITE3 1 "Mon Jan 31 11:14:00 2014" |
+.TH SQLITE3 1 "Fri Oct 31 10:41:31 EDT 2014" |
.\" Please adjust this date whenever revising the manpage. |
.\" |
.\" Some roff macros, for reference: |
@@ -49,7 +49,7 @@ a table named "memos" and insert a couple of records into that table: |
$ |
.B sqlite3 mydata.db |
.br |
-SQLite version 3.8.3 |
+SQLite version 3.8.8 |
.br |
Enter ".help" for instructions |
.br |
@@ -107,26 +107,29 @@ the '.help' command. For example: |
sqlite> |
.B .help |
.nf |
-.cc | |
-.backup ?DB? FILE Backup DB (default "main") to FILE |
-.bail ON|OFF Stop after hitting an error. Default OFF |
-.databases List names and files of attached databases |
-.dump ?TABLE? ... Dump the database in an SQL text format |
+.tr %. |
+%backup ?DB? FILE Backup DB (default "main") to FILE |
+%bail on|off Stop after hitting an error. Default OFF |
+%clone NEWDB Clone data into NEWDB from the existing database |
+%databases List names and files of attached databases |
+%dump ?TABLE? ... Dump the database in an SQL text format |
If TABLE specified, only dump tables matching |
LIKE pattern TABLE. |
-.echo ON|OFF Turn command echo on or off |
-.exit Exit this program |
-.explain ?ON|OFF? Turn output mode suitable for EXPLAIN on or off. |
+%echo on|off Turn command echo on or off |
+%eqp on|off Enable or disable automatic EXPLAIN QUERY PLAN |
+%exit Exit this program |
+%explain ?on|off? Turn output mode suitable for EXPLAIN on or off. |
With no args, it turns EXPLAIN on. |
-.header(s) ON|OFF Turn display of headers on or off |
-.help Show this message |
-.import FILE TABLE Import data from FILE into TABLE |
-.indices ?TABLE? Show names of all indices |
+%fullschema Show schema and the content of sqlite_stat tables |
+%headers on|off Turn display of headers on or off |
+%help Show this message |
+%import FILE TABLE Import data from FILE into TABLE |
+%indices ?TABLE? Show names of all indices |
If TABLE specified, only show indices for tables |
matching LIKE pattern TABLE. |
-.load FILE ?ENTRY? Load an extension library |
-.log FILE|off Turn logging on or off. FILE can be stderr/stdout |
-.mode MODE ?TABLE? Set output mode where MODE is one of: |
+%load FILE ?ENTRY? Load an extension library |
+%log FILE|off Turn logging on or off. FILE can be stderr/stdout |
+%mode MODE ?TABLE? Set output mode where MODE is one of: |
csv Comma-separated values |
column Left-aligned columns. (See .width) |
html HTML <table> code |
@@ -135,31 +138,35 @@ sqlite> |
list Values delimited by .separator string |
tabs Tab-separated values |
tcl TCL list elements |
-.nullvalue STRING Use STRING in place of NULL values |
-.open ?FILENAME? Close existing database and reopen FILENAME |
-.output FILENAME Send output to FILENAME |
-.output stdout Send output to the screen |
-.print STRING... Print literal STRING |
-.prompt MAIN CONTINUE Replace the standard prompts |
-.quit Exit this program |
-.read FILENAME Execute SQL in FILENAME |
-.restore ?DB? FILE Restore content of DB (default "main") from FILE |
-.schema ?TABLE? Show the CREATE statements |
+%nullvalue STRING Use STRING in place of NULL values |
+%once FILENAME Output for the next SQL command only to FILENAME |
+%open ?FILENAME? Close existing database and reopen FILENAME |
+%output ?FILENAME? Send output to FILENAME or stdout |
+%print STRING... Print literal STRING |
+%prompt MAIN CONTINUE Replace the standard prompts |
+%quit Exit this program |
+%read FILENAME Execute SQL in FILENAME |
+%restore ?DB? FILE Restore content of DB (default "main") from FILE |
+%save FILE Write in-memory database into FILE |
+%schema ?TABLE? Show the CREATE statements |
If TABLE specified, only show tables matching |
LIKE pattern TABLE. |
-.separator STRING Change separator used by output mode and .import |
-.show Show the current values for various settings |
-.stats ON|OFF Turn stats on or off |
-.tables ?TABLE? List names of tables |
+%separator STRING ?NL? Change separator used by output mode and .import |
+ NL is the end-of-line mark for CSV |
+%shell CMD ARGS... Run CMD ARGS... in a system shell |
+%show Show the current values for various settings |
+%stats on|off Turn stats on or off |
+%system CMD ARGS... Run CMD ARGS... in a system shell |
+%tables ?TABLE? List names of tables |
If TABLE specified, only list tables matching |
LIKE pattern TABLE. |
-.timeout MS Try opening locked tables for MS milliseconds |
-.trace FILE|off Output each SQL statement as it is run |
-.vfsname ?AUX? Print the name of the VFS stack |
-.width NUM1 NUM2 ... Set column widths for "column" mode |
-.timer ON|OFF Turn the CPU timer measurement on or off |
+%timeout MS Try opening locked tables for MS milliseconds |
+%timer on|off Turn SQL timer on or off |
+%trace FILE|off Output each SQL statement as it is run |
+%vfsname ?AUX? Print the name of the VFS stack |
+%width NUM1 NUM2 ... Set column widths for "column" mode |
+ Negative values right-justify |
sqlite> |
-|cc . |
.sp |
.fi |
.SH OPTIONS |
@@ -269,7 +276,7 @@ o If the -init option is present, the specified file is processed. |
o All other command line options are processed. |
.SH SEE ALSO |
-http://www.sqlite.org/ |
+http://www.sqlite.org/cli.html |
.br |
The sqlite3-doc package. |
.SH AUTHOR |