.Dd Created:2026-03-24|Updated:2026-03-24|
.de ocsi
\\$*
,
..
.de oxr
.ocsi .Xr \\$*
..
.de oit
.It
\\$*
..
.de obdi
.Bl -dash -compact
.oit \\$*
..
.de obdl
.Bd -literal -compact
\\$*
..
.de onote
.Bl -hang -compact
.oit \\$*
.El
..
.de ocomm
.Bl -diag -compact
.oit \\$*
.El
..
.de opsy
.Pp
.Sy - \\$*
..
.de obc
.Bl -column \\$*
..
.de obc2
.obc opt desc
..
.de obc3
.obc option arguments description
..
.Dt SQLITE3 oh
.Os linux , OpenBSD 7.8 |
.Nm SQLite3 
.Nd usage and tips
.Sh COMMANDS
.Ss exit
Type
.Li \\&.quit
to exit.
.Ss standard usage
.Bd -literal -compact
sqlite3 [database] "COMMAND|QUERY"
.Ed
.Ss sqlite3 commands
.Bl -compact
.It
\&.fullschema will retrieve all the tables and their fields from the db.
.It
\&.tables will retrieve all the tables from the db.
.It
\&.schema [table] will retrieve the fields from a table.
.El
.Sh SEE ALSO
.oxr sql oh
.Xr mysql oh
.opsy Archlinux manpages:
.Xr sqlite3 1
.Ss links
.obc2
.It - Lk https://www.sqlite.org/ SQLite
.El
.Sh AUTHORS
.An -nosplit
.Xr ohazot oh |
.Xr about oh |
.Lk https://ohazot.com ohazot.com
.Aq Mt admin@ohazot.com