SQLite Forum

Connect to sample Database
Login
I am on the tutorial:
https://www.sqlitetutorial.net/sqlite-sample-database/

STEP 1:
Instruction is: navigate to the C:\sqlite folde

Code is : C:\>cd\sqlite

result is: C:\sqlite>

STEP 2:

Instruction is: type sqlite3 and press enter

Code is: C:\>cd\sqlite

result is: C:\sqlite>

STEP 3:
Instruction is: type sqlite3 and press enter, you should see the following output

Code is: C:\sqlite>sqlite3

Result is (and it compares to the example):

SQLite version 3.33.0 2020-08-14 13:23:32
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite>

STEP 4
Instruction: type the .help command from the sqlite> prompt to see all available commands in sqlite3.

Code is:  sqlite> .help

Result is: a list of help commands / information similar to example

STEP 5
Instruction: it tells you to quit and to download a GUI.  I am not quitting, and moving on to the next instructions to download and unzip the demo file called chinook.db

Mine is in a folder called : C:\sqlite\db


STEP 6:
Instruction: use the following command to connect to the chinook sample database located in the db folder, which is a subfolder of the sqlite folder.

Code: C:\sqlite>sqlite3 c:\db\chinook.db

Result:
SQLite version 3.33.0 2020-08-14 13:23:32
Enter ".help" for usage hints.
sqlite>

It says I should see a folder called sqlite> which I do

STEP 7:
Instruction: try a simple command like seeing the tables

Code: sqlite> .tables

Result: 
Error: unable to open database "c:\db\chinook.db": unable to open database file

I hope this makes more sense.  Sorry, I am doing everything in DOS CMD and think I am doing it right, but in case you have not noticed, I am not a guru :-)