TLDRBins TLDRBins / SQLite

Usage Tips:

  • Click on a keyword to enable inline editing.
  • Click inside a code block to copy (excludes comments).
  • Use the button to view examples.
  • Click outside to collapse all examples.

General

# Open a db
sqlite3 <DB_FILE>

Sample Output:
TO-DO
# Show tables
.tables

Sample Output:
TO-DO
# Show schema of a table
.schema <TABLE_NAME>

Sample Output:
TO-DO
# Show column headers
.headers on

Sample Output:
TO-DO
# Dump data
select * from <TABLE_NAME>;

Sample Output:
TO-DO