_                    _
  ___ | |__   __ _ _______ | |_
 / _ \| '_ \ / _` |_  / _ \| __|
| (_) | | | | (_| |/ / (_) | |_
 \___/|_| |_|\__,_/___\___/ \__|

SQLite3 — usage and tips

sqlite3 [<database>] "[<command>|<query>]"

Type .quit to exit.

  • .fullschema will retrieve all the tables and their fields from the db.
  • .tables will retrieve all the tables from the db.
  • .schema [table] will retrieve the fields from a table.

(back to top)

sql, mysql
VoidLinux manpages: sqlite3(1)
links
- SQLite

(back to top)

2026-07-11 : Translated to Spanish.
2026-03-24 : Created.

(back to top)

ohazot | about | ohazot.com <admin@ohazot.com>

This document applies to: linux , OpenBSD 7.8 | 2026-03-24