sqlite3 commands

sqlite3.sh

# Open database
sqlite3 mydata.db

# Select rows from table
SELECT * from memos;

# Delete table
DROP TABLE memos;

# Truncate table (Delete every row)
DELETE FROM migrations;

# Show table structure
PRAGMA table_info(users);

# meta commands
.tables
.exit