Source-Changes-HG archive
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index][Old Index]
[src/trunk]: src/external/public-domain/sqlite/dist Fix some obvious problems...
details: https://anonhg.NetBSD.org/src/rev/78075aa33fdc
branches: trunk
changeset: 783367:78075aa33fdc
user: wiz <wiz%NetBSD.org@localhost>
date: Sun Dec 16 23:37:34 2012 +0000
description:
Fix some obvious problems and remove trailing whitespace.
Use more markup.
diffstat:
external/public-domain/sqlite/dist/sqlite3.1 | 99 ++++++++++++++-------------
1 files changed, 51 insertions(+), 48 deletions(-)
diffs (182 lines):
diff -r 9cc16fedf76c -r 78075aa33fdc external/public-domain/sqlite/dist/sqlite3.1
--- a/external/public-domain/sqlite/dist/sqlite3.1 Sun Dec 16 23:00:46 2012 +0000
+++ b/external/public-domain/sqlite/dist/sqlite3.1 Sun Dec 16 23:37:34 2012 +0000
@@ -1,12 +1,12 @@
-.\" $NetBSD: sqlite3.1,v 1.2 2012/12/16 20:25:40 christos Exp $
+.\" $NetBSD: sqlite3.1,v 1.3 2012/12/16 23:37:34 wiz Exp $
.Dd December 16, 2012
.Dt SQLITE3 1
.Os
.Sh NAME
-.Nm sqlite3
+.Nm sqlite3
.Nd A command line interface for SQLite version 3
.Sh SYNOPSIS
-.Nm
+.Nm
.Op Ar options
.Op Ar databasefile
.Op Ar SQL
@@ -19,13 +19,13 @@
batch processing features.
.Pp
To start a
-.Nm
+.Nm
interactive session, invoke the
.Nm
command and optionally provide the name of a database file.
If the database file does not exist, it will be created.
If the database file does exist, it will be opened.
-
+.Pp
For example, to create a new database file named "mydata.db", create
a table named "memos" and insert a couple of records into that table:
.Bd -literal -offset indent
@@ -41,7 +41,7 @@
sqlite>
.Ed
.Pp
-If no database name is supplied, the
+If no database name is supplied, the
.Em ATTACH
sql command can be used
to attach to existing or create new database files.
@@ -66,7 +66,7 @@
used to control the output format, examine the currently attached
database files, or perform administrative operations upon the
attached databases (such as rebuilding indices).
-Meta-commands are always prefixed with a dot
+Meta-commands are always prefixed with a dot
.Dq \. .
.Pp
A list of available meta-commands can be viewed at any time by issuing
@@ -74,17 +74,16 @@
For example:
.Bd -literal -offset indent
sqlite> .help
-.cc |
-.databases List names and files of attached databases
-.dump ?TABLE? ... Dump the database in an SQL text format
-.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.
-.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 on TABLE
-.mode MODE ?TABLE? Set output mode where MODE is one of:
+\&.databases List names and files of attached databases
+\&.dump ?TABLE? ... Dump the database in an SQL text format
+\&.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.
+\&.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 on TABLE
+\&.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
@@ -93,23 +92,22 @@
list Values delimited by .separator string
tabs Tab-separated values
tcl TCL list elements
-.nullvalue STRING Print STRING in place of NULL values
-.output FILENAME Send output to FILENAME
-.output stdout Send output to the screen
-.prompt MAIN CONTINUE Replace the standard prompts
-.quit Exit this program
-.read FILENAME Execute SQL in FILENAME
-.schema ?TABLE? Show the CREATE statements
-.separator STRING Change separator used by output mode and .import
-.show Show the current values for various settings
-.tables ?PATTERN? List names of tables matching a LIKE pattern
-.timeout MS Try opening locked tables for MS milliseconds
-.width NUM NUM ... Set column widths for "column" mode
+\&.nullvalue STRING Print STRING in place of NULL values
+\&.output FILENAME Send output to FILENAME
+\&.output stdout Send output to the screen
+\&.prompt MAIN CONTINUE Replace the standard prompts
+\&.quit Exit this program
+\&.read FILENAME Execute SQL in FILENAME
+\&.schema ?TABLE? Show the CREATE statements
+\&.separator STRING Change separator used by output mode and .import
+\&.show Show the current values for various settings
+\&.tables ?PATTERN? List names of tables matching a LIKE pattern
+\&.timeout MS Try opening locked tables for MS milliseconds
+\&.width NUM NUM ... Set column widths for "column" mode
sqlite>
-|cc .
.Ed
.Sh OPTIONS
-.Nm
+.Nm
has the following options:
.Bl -tag -width abcdefghij
.It Fl init Ar file
@@ -142,10 +140,10 @@
.It Fl nullvalue Ar string
Set
.Ar string
-used to represent
+used to represent
.Dv NULL
values.
-Default is
+Default is
.Dq \e
(empty string).
.It Fl version
@@ -157,31 +155,36 @@
.Nm
reads an initialization file to set the configuration of the
interactive environment.
-Throughout initialization, any previously specified setting can be overridden. The sequence of initialization is as follows:
-.Bl
-.It The default configuration is established as follows:
-.sp
+Throughout initialization, any previously specified setting can be overridden.
+The sequence of initialization is as follows:
+.Bl -enum
+.It
+The default configuration is established as follows:
.Bd -literal -offset indent
-.cc |
mode = LIST
separator = "|"
main prompt = "sqlite> "
continue prompt = " ...> "
-|cc .
.Ed
-.It If the file
+.It
+If the file
.Fi ~/.sqliterc
exists, it is processed first.
can be found in the user's home directory, it is
read and processed.
It should generally only contain meta-commands.
-.It If the -init option is present, the specified file is processed.
-.It All other command line options are processed.
+.It
+If the
+.Fl init
+option is present, the specified file is processed.
+.It
+All other command line options are processed.
.El
.Sh SEE ALSO
-http://www.sqlite.org/
-.Sh AUTHOR
+.Lk http://www.sqlite.org/
+.Sh AUTHORS
This manual page was originally written by Andreas Rottmann
-\*[Lt]rotty%debian.org@localhost\*[Gt], for the Debian GNU/Linux system (but may be used
-by others).
-It was subsequently revised by Bill Bumgarner \*[Lt]bbum%mac.com@localhost\*[Gt].
+.Aq rotty%debian.org@localhost ,
+for the Debian GNU/Linux system (but may be used by others).
+It was subsequently revised by Bill Bumgarner
+.Aq bbum%mac.com@localhost .
Home |
Main Index |
Thread Index |
Old Index