🖥️sqlite3

➡️This is a command-line reference manual for commands and command combinations that you don’t use often enough to remember it. This cheatsheet explains the sqlite3 command with important options and switches using examples.

2 minute read

▁ ▂ ▃ ▄ ꧁ 🔴☠ COMMANDLINE-KUNGFU WITH CHEATSHEETS ☠🔴꧂▅ ▃ ▂ ▁

#                ███████╗ ██████╗ ██╗     ██╗████████╗███████╗██████╗ 
#                ██╔════╝██╔═══██╗██║     ██║╚══██╔══╝██╔════╝╚════██╗
#                ███████╗██║   ██║██║     ██║   ██║   █████╗   █████╔╝
#                ╚════██║██║▄▄ ██║██║     ██║   ██║   ██╔══╝   ╚═══██╗
#                ███████║╚██████╔╝███████╗██║   ██║   ███████╗██████╔╝
#                ╚══════╝ ╚══▀▀═╝ ╚══════╝╚═╝   ╚═╝   ╚══════╝╚═════╝ 
                                                                     
                

# create database and launch interactive shell
sqlite3 example.db

# create table
sqlite3 example.db "CREATE TABLE Os(ID INTEGER PRIMARY KEY, Name TEXT, Year INTEGER);"

# insert data
sqlite3 example.db "INSERT INTO 'Os' VALUES(1,'Linux',1991);"

# list tables
sqlite3 example.db ".tables"

# view records in table
sqlite3 example.db "SELECT * FROM 'Os';"

# view records in table conditionally
sqlite example.db "SELECT * FROM 'Os' WHERE Year='1991';"

# view records with fuzzy matching
sqlite3 ~/example.db "SELECT * FROM 'Os' WHERE Year like '19%';"

#==============================##==============================#
# CMD SQLITE3						       #
#==============================##==============================#

Cheatsheets are an excellent complement to other information sources like Linux man-pages, Linux help, or How-To’s and tutorials, as they provide compact and easily accessible information. While man-pages and detailed tutorials often contain comprehensive explanations and extensive guides, cheatsheets summarize the most important options forthe command sqlite3 in a clear format. This allows users to quickly access the needed information for sqlite3 without having to sift through lengthy texts. Especially in stressful situations or for recurring tasks, cheatsheets for sqlite3 are a valuable resource to work efficiently and purposefully.

░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░

  █║▌│║█║▌★ KALI ★ PARROT ★ DEBIAN 🔴 PENTESTING ★ HACKING ★ █║▌│║█║▌

              ██╗ ██╗ ██████╗  ██████╗ ██╗  ██╗███████╗██████╗
             ████████╗██╔══██╗██╔═══██╗╚██╗██╔╝██╔════╝██╔══██╗
             ╚██╔═██╔╝██║  ██║██║   ██║ ╚███╔╝ █████╗  ██║  ██║
             ████████╗██║  ██║██║   ██║ ██╔██╗ ██╔══╝  ██║  ██║
             ╚██╔═██╔╝██████╔╝╚██████╔╝██╔╝ ██╗███████╗██████╔╝
              ╚═╝ ╚═╝ ╚═════╝  ╚═════╝ ╚═╝  ╚═╝╚══════╝╚═════╝

               █║▌│║█║▌ WITH COMMANDLINE-KUNGFU POWER █║▌│║█║▌

░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░

Feedback

Was this page helpful?

Glad to hear it! Please tell us how we can improve.

Sorry to hear that. Please tell us how we can improve.