I am trying to create a sqlite3 database on my windows 7 64 bit machine. I have downloaded sqlite-shell-win32-x86-3071700.zip from http://www.sqlite.org/download.html . After running the sqlite3.exe on my Desktop, I ran the following:
sqlite > sqlite3 mytest.db
after I pressed enter it just printed out
... >
Unable to create sqlite3 database on windows 7 64 bit machine
I noticed someone had a similar problem has me so I tried running it through the Windows command prompt. However I still got the same output
.... >
When I use a semicolon after mytest.db I get the error the guys gets in the above link, even in the Windows command prompt.
Any help is appreciated.
Thanks in advance.
Start the sqlite3 program by typing "sqlite3" at the command prompt, optionally followed by the name the file that holds the SQLite database (or ZIP archive). If the named file does not exist, a new database file with the given name will be created automatically.
In SQLite, the sqlite3 command is used to create a new database. Syntax: sqlite3 DatabaseName. db.
First, go to SQLite's official website download page and download precompiled binaries from Windows section. Once the download is completed, you should see the downloaded file in the Windows Downloads directory. Next, right click on the downloaded file and extract it inside the C:\sqlite directory.
sqlite3 mytest.db ""
See those ""
at the end - they are needed if you want to create empty database
For Powershell use sqlite3 mytest.db " "
Powershell needs space between " "
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With