Difference between revisions of "Search an SQL database using sqlite3"
Jump to navigation
Jump to search
Line 20: | Line 20: | ||
You can then display tables with: | You can then display tables with: | ||
<syntaxhighlight lang=" | <syntaxhighlight lang="bash"> | ||
.tables | .tables | ||
</syntaxhighlight> | </syntaxhighlight> | ||
Line 26: | Line 26: | ||
Based on what is returned, you can then query the content of each table with commands such as: | Based on what is returned, you can then query the content of each table with commands such as: | ||
<syntaxhighlight lang=" | <syntaxhighlight lang="bash"> | ||
SELECT * FROM users | SELECT * FROM users | ||
</syntaxhighlight> | </syntaxhighlight> | ||
Line 32: | Line 32: | ||
You may want to have a more human-readable view of the data that is printed in the terminal, by organising the headings and columns: | You may want to have a more human-readable view of the data that is printed in the terminal, by organising the headings and columns: | ||
<syntaxhighlight lang=" | <syntaxhighlight lang="bash" line> | ||
.headers ON | .headers ON | ||
.mode columns | .mode columns |
Revision as of 16:25, 14 November 2021
https://www.sqlite.org/index.html
sqlite
implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine to query .sql
files.
Getting started
To use sqlite, you must have a valid metadata file with a .db
file extension, and an installed version of SQL. This tutorial assumes knowledge of the command line.
To start the sql engine, type:
sqlite3
The prompt will change, showing that the sqlite engine has been initialised. To open a metadata file, type:
.open filename.db
You can then display tables with:
.tables
Based on what is returned, you can then query the content of each table with commands such as:
SELECT * FROM users
You may want to have a more human-readable view of the data that is printed in the terminal, by organising the headings and columns:
.headers ON
.mode columns