/sqlite3-docs

figuring out how to explore data using sqlite3

sqlite3-docs

figuring out how to explore data using sqlite3

How to use sqlite3 to explore a database from the terminal

  • Open a database using sqlite3 with the command: sqlite3 ./dname.db Now you are connected to the database
  • To check what database your are connected to use the .database command
  • To exit use .exit
  • To show the tables use .tables
  • To display the structure of a table, you use the .schema TABLE command
  • now use the usual sql commands to explore the data
  • you could use SELECT * FROM tablename