sqlite
Package: WA2L/edrc 1.5.57
Section: General Commands (1)
Updated: 17 March 2009
Index
Return to Main Contents
NAME
sqlite - command-line access program for SQLite databases
SYNOPSIS
edrc/bin/sqlite
[
-help
|
-version
]
sqlite
[
-init filename
] [
-echo
] [
-[no]header
] [
-bail
] [
-interactive
] [
-batch
] [
-column
] [
-csv
] [
-html
] [
-line
] [
-list
] [
-separator aqxaq
] [
-nullvalue aqtextaq
] [
FILENAME
[
SQL
] ]
AVAILABILITY
WA2L/edrc
DESCRIPTION
SQLite is a software library that implements a
self-contained, serverless, zero-configuration,
transactional SQL database engine.
SQLite is the most widely deployed SQL database engine
in the world. It is used in countless desktop computer
applications as well as consumer electronic devices
including cellphones, PDAs, and MP3 players. The source
code for SQLite is in the public domain.
The SQLite library includes a simple command-line
utility named
sqlite3
that allows the user to manually enter
and execute SQL commands against an SQLite database.
In the WA2L/edrc package the command is provided under the name
sqlite.
Therefore whenever the command
sqlite3
is referenced in the HTML documentation, replace it with
sqlite.
This man page provides a brief introduction to the
options of
sqlite
and provides the link to the HTML documentation.
OPTIONS
- -help
-
usage message.
- -echo
-
print commands before execution.
- -[no]header
-
turn headers on or off.
- -bail
-
stop after hitting an error.
- -interactive
-
force interactive I/O.
- -batch
-
force batch I/O.
- -column
-
set output mode to
aqcolumnaq
.
- -csv
-
set output mode to
aqcsvaq
.
- -html
-
set output mode to
aqHTMLaq
.
- -init filename
-
read/process commands from the
filename.
- -line
-
set output mode to
aqlineaq
.
- -list
-
set output mode to
aqlistaq
.
- -separator aqxaq
-
set output field separator (|).
- -nullvalue aqtextaq
-
set text string for NULL values.
- -version
-
show SQLite version.
- FILENAME
-
database file name.
- SQL
-
SQL statements.
ENVIRONMENT
See HTML SQLite documentation in
https://sqlite.org/cli.html.
EXIT STATUS
See HTML SQLite documentation in
https://sqlite.org/cli.html.
FILES
See HTML SQLite documentation in
https://sqlite.org/docs.html.
- lib/$OSID/includes/sqlite3.h
-
include file.
- lib/$OSID/includes/sqlite3ext.h
-
include file.
EXAMPLES
See HTML SQLite documentation in
https://sqlite.org/cli.html.
SEE ALSO
edrcintro(1),
thttpd(3),
http://www.sqlite.org,
https://sqlite.org/cli.html,
https://sqlite.org/docs.html,
https://sqlite.org/lang.html,
https://www.sqlitetutorial.net/
NOTES
Parts of this manual page
were extracted from the
sqlite3
HTML documentation distributed with the SQLite
version 3.6.3, written by
"The SQLite Development Team" led by
D. Richard Hipp, Dan Kennedy and Shane Harrelson.
BUGS
-
AUTHOR
sqlite was developed by D. Richard Hipp, Dan Kennedy
and Shane Harrelson and integrated into WA2L/edrc by
Christian Walther. Send suggestions
and bug reports related to the integration to
wa2l@users.sourceforge.net .
COPYRIGHT
Copyright © 2009
Christian Walther
This is free software; see
edrc/doc/COPYING
for copying conditions. There is ABSOLUTELY NO WARRANTY; not
even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
This document was created by man2html
using the manual pages.
Time: 16:54:28 GMT, August 28, 2024