SQLite Knowledge Base

Aus MattWiki
Version vom 6. April 2024, 20:33 Uhr von Matt (Diskussion | Beiträge)
(Unterschied) ← Nächstältere Version | Aktuelle Version (Unterschied) | Nächstjüngere Version → (Unterschied)

This article contains basic knowledge, commands and how to's for SQLite.

SQLite is the most used database engine in the world.

General Information

Open database.sqlite with sqlite CLI client:

sqlite database.sqlite

Within SQLite CLI interface

Command Description
.help Help
.exit Quit
.tables List tables in database
.schema [<tablename>] Show database table description, optionally for a given table name