SQLite3

Basics

  • DB is actually in a File/Dir

> file [FILENAME]       ..to check the filetype/info
> sqlite3 [FILENAME]    ..to connect

.tables    ... to get a list of tables.
SELECT     ... to extract the content of a table using SQL.

Last updated