CODEWITHSUNDEEP
windowssqlite
user575219
user575219

Reputation: 2442

sqlite from command prompt- not recognized command

I am trying to run sqlite from the command prompt. So I have this downloaded sqlite-shell-win32-x86-3071100.zip from this website http://www.sqlite.org/download.html

Now there is a set up.exe from which v can run sqlite commands. When I say 

C:\Users\..>'sqlite3' is not recognized as an internal or external com

''sqlite3'' is not recognized as an internal or external command,
operable program or batch file.

Any hints.

Thank you Sun

Upvotes: 10

Views: 62534

Answers (6)

Awais
Awais

Reputation: 3

download package for your system form here

https://www.sqlite.org/download.html

After extracting.

Put the folder into c:/ drive

from there go into the folder, when you see .exe files copy the file explorer address. and add a new environment variable with the copied address.

Hurray, go and type sqlite3 in command prompt see if it worked.

Upvotes: 0

mrmicrowaveoven
mrmicrowaveoven

Reputation: 185

If your sqlite3.exe is in C:\Stuff, you can check really quick to see if it's in your PATH.

echo %PATH% will give you your full path. If you don't see ;C:\Stuff there (probably near the end), that's why windows can't find sqlite3.exe.

If you don't see it, run:

setx path "%PATH%;C:\Stuff"

That should be problem solved. Open a new command prompt (it only updates PATHS when the terminal opens), run echo %PATH% and you should now see ;C:\Stuff at the end.

Congrats. sqlite should work in the terminal moving forward.

Upvotes: 0

user14415505
user14415505

Reputation: 11

It maybe possible that when u have extracted files from the downloaded zip folder,2 folders are created of the same name one inside the other. So in the cmd prompt u have to enter that folder 2 times by using . E.g-C:....\sqlite-tools-win32-x86-3330000\sqlite-tools-win32-x86-3330000 and then use sqlite3

Upvotes: 1

Suman Deol
Suman Deol

Reputation: 382

Go to an environment variable and add new environment variable C:\sqlite as I have saved the sqlite3 files under sqlite folder of C drive. It worked for me

Upvotes: 1

Alex28034
Alex28034

Reputation: 47

I assume that you already have sqlite in your system path since the instructions on how to do this are clear.

The likely problem is that you have created a folder called sql3 and have put the three executable files in a folder within that folder.

Check that all three executable files are within the file itself.

Upvotes: 1

user610650
user610650

Reputation:

From your windows command prompt, you can start sqlite3 either with:

cd c:\Stuff
sqlite3.exe

or with:

c:\Stuff\sqlite3.exe

Either way, I assume from your comment that sqlite3.exe is in c:\Stuff.

As Michael mentioned, you can also add the path of the directory containing sqlite3.exe to your PATH. Fro a quick search I found this guide: http://geekswithblogs.net/renso/archive/2009/10/21/how-to-set-the-windows-path-in-windows-7.aspx

Upvotes: 14

Related Questions