Skip to content

SQLite

Install

Almalinux

dnf install epel-release -y
dnf install sqlite-devel -y

Open database

sqlite3 /foo/bar/sqlite.db

Queries and command

https://www.sqlite.org/cli.html

Show existing tables

.tables

Show table fields:

PRAGMA table_info(table);