SQLite Forum

sqlite3 does not run from command line
Login

sqlite3 does not run from command line

(1) By Arri11 on 2020-12-30 22:38:31 [link] [source]

Hi - apologies I am very new to this. 

If I double click on sqlite3.exe in explorer I get the following 

SQLite version 3.34.0 2020-12-01 16:14:00
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite>

If I try to run from the command line ( as administrator or not ) - I get the following 

C:\Users\User>sqlite3

C:\Users\User>

It appears to run nothing and does not start sqlite3.

I have set the path and environment variable 

SET command returns 
sqlite3=C:\sqlite\sqlite3.exe

PATH contains 
C:\sqlite;

Any help appreciated as to why sqlite3 command will not run - thanks

(2) By Warren Young (wyoung) on 2020-12-30 23:24:35 in reply to 1 [link] [source]

What does "where sqlite3" say?

(3) By Arri11 on 2020-12-30 23:34:39 in reply to 1 [link] [source]

Hi - thanks for reply

where sqlite3

c:sqlite\sqlite3.exe

(4) By anonymous on 2020-12-31 08:20:45 in reply to 1 [source]

You appear to be using Windows; if so:

  • Using File Explorer, navigate to C:\SQLite
  • Right-Click on SQLite3.EXE and then select Send to and then Desktop (create shortcut)
  • Locate the shortcut on your Desktop, right-click and then click Properties
  • In the Start in box, specify C:\SQLite

Double-click on the desktop icon to start SQLite3 CLI application.

  • You NEITHER need to add C:\SQLite to your path i.e. modify your PATH environment1 variable NOR do you need to copy SQLIte3 files into any new or existing operating system folder such as System or System32

1You should undo the change you have already made.

(5) By Arri11 on 2020-12-31 10:18:10 in reply to 4 [link] [source]

Thanks very much for your help - I followed that and it solves my problem