---
tags: [ database ]
---
# To create database and launch interactive shell:
sqlite3 <database>

# To create table:
sqlite3 <database> "create table os(id integer primary key, name text, year integer);"

# To insert data:
sqlite3 <database> "insert into 'os' values(1,'linux',1991);"

# To list tables:
sqlite3 <database> ".tables"

# To describe table:
sqlite3 <database> ".schema 'os'"

# To view records in table:
sqlite3 <database> "select * from 'os';"

# To view records in table conditionally:
sqlite3 <database> "select * from 'os' where year='1991';"

# To view records with fuzzy matching:
sqlite3 <database> "select * from 'os' where year like '19%';"

# To create a table named `cities` and import a csv into it:
sqlite3 <database> ".import /path/to/city.csv cities"
