A database in one file
Use the SQLite shell
Open a database, run SQL, and use dot commands to inspect the shell without confusing them with SQL statements.
8 minute lesson
~~~
Open a database file from the terminal:
sqlite3 notes.dbCommands that start with a dot belong to the shell. Try .databases, .tables, .schema, and .help. SQL statements such as SELECT 1; end with a semicolon.
Lesson completed