SQLite Basics

| 1 min read

Week Of: 2021-11-28
2021-11-30

home/Professional

SQLite basics

Install

go to: Precompiled Binaries for Windows in: https://www.sqlite.org/download.html
and download the file.

locate the sqlite3 file in your preffered directory.

Start using

there you should run the command:

sqlite3 kanban.db

where the kanban.db is the db binary file.

Basic Help

.help

Export the next command to Excel file

.excel --bom

where the --bom is for the Hebrew characters (UTF-8)

Show your all tables

.tables

SQL Commands

select * from card;