Hello, I downloaded https://www.sqlite.org/2020/sqlite-tools-win32-x86-3310100.zip the sqlite-tools-win32-x86-3310100.zip option, on windows 10 and when I use the sqlite3 of it, and I'm trying to open the general empty file I created or the db file that I created, it just ignores it and create a new file where this program is installed with a name of the main folder, and even if I try to use that file that he created it would ignore it and create another one.

any thought on why it does it or how can I fix it?

To Gunter's point: You (the OP) should also show how you extracted from the .zip archive and where the .exe files ended up. It's not hard, but you do have to get them either into a directory named in the PATH environment variable or into the directory from which you invoked sqlite3.exe .

If you are clicking on things rather than typing into a CMD shell (or equivalent), you should spell that out too.

You will have to show what you a actually doing that leads to disappointment, and what the actual results were, rather than summarizing it. That would be information such as what you typed to invoke sqlite3.exe, what you typed when it was running, what the responses were, and if not obvious, what you expected.

FYI, the very tools within the .zip I downloaded using the above URL work just fine on Windows 10. So your problem is something odd that you are doing. Show us, and somebody will explain.

Edit (for and based on the replies I got) :

I installed the package on my D drive (I also tried converting it into my C drive, same results) in my college folder, in that address: D:\Users\Lidor\College\Databases\SQLite\sqlite-tools-win32-x86-3310100.zip I did the "Unzip here" option and got that folder (D:\Users\Lidor\College\Databases\SQLite\sqlite-tools-win32-x86-3310100), inside of it there 3 items:

1. sqldiff
2. sqlite3
3. sqlite3_analyzer

I created an empty file name MyDB and a db file name MyDB2, and then I double click the second option (the sqlite3), in it I write this command:

sqlite> .open D:\Users\Lidor\College\Databases\SQLite\sqlite-tools-win32-x86-3310100\MyDB2

and then it goes to next line, shows no errors, and when I check the folder, it ignored my files and created a general file name UsersLidor in the same folder. (I tried with MyDB and with MyDB2, same result). and ofc when I type the sqlite> .database, it shows the file that he created, but if I ever try to use it or change it's name it will again create the same file with the name UsersLidor.

regarding some of the answers I got, what does it mean to install it on the PATH?