SQLITE3 Commands Cheat Sheet
Here is a cli commands cheat sheet for SQLITE3 command, you can use this as a quick reminder for basic commands with a brief description for each of the commands.
What is SQLITE3 command?
Add some data here
--- tags: [ database ] --- # To create database and launch interactive shell: sqlite3# To create table: sqlite3 "create table os(id integer primary key, name text, year integer);" # To insert data: sqlite3 "insert into 'os' values(1,'linux',1991);" # To list tables: sqlite3 ".tables" # To describe table: sqlite3 ".schema 'os'" # To view records in table: sqlite3 "select * from 'os';" # To view records in table conditionally: sqlite3 "select * from 'os' where year='1991';" # To view records with fuzzy matching: sqlite3 "select * from 'os' where year like '19%';" # To create a table named `cities` and import a csv into it: sqlite3 ".import /path/to/city.csv cities"
Check out the SQLITE3 command documentation .
You can also check our MegaSh cheatsheet tool, that has 150+ searchable linux cheat sheets in one page, so you never forget a command as you work again
Check Also
