sqlite3 use
2025-09-20
shows database table
sqlite3 notes.db .tables
view the complete structure of all tables
sqlite3 notes.db .schema
Search the notes table and print out the contents of id 7
sqlite3 notes.db "SELECT * FROM notes WHERE id = 7;"