Creating sqlite3 files/database

Question

I am struggling to create a database using SQLite3 using Windows 7.

SLite3 is currently installed:

C:\Program Files (x86)\Development\

and has sqlite3.def, sqlite3.dll and a sqlite3 (.exe) file.

I have also updated the environment variable of Path to:

C:\Program Files (x86)\Development\

When I double click:

sqlite3.exe

It opens up the command prompt with the address at the top as:

C:\Program Files (x86)\Development\sqlite3.exe

It opens up and is:

"Connected to a transient in-memory database."
(transient in-memory database) is in red text

Looking around this means that it saves to memory and not hard disk but if you specify:

.save testDB

Then all should be good, but not for me. I have tried:

sqlite3 testDB.db
.save testDB
create table tbl1(one varchar(10), two smallint);

But I get the error:

Error: near "sqlite3" syntax error

Any ideas what I'm doing wrong? I have SQLite manager installed too but I assume I can't use that until a database is saved to disk?

Thanks.

Would changing my Path variable to:

C: \Program Files (x86)\Development\

Make any difference i.e. a space between : and the \?

goto the link point number 2. sqlite.org/cli.html

saurav
– saurav

2018-04-16 21:05:53 +00:00
Commented Apr 16, 2018 at 21:05 — saurav
– saurav, Commented Apr 16, 2018 at 21:05

sedeh · Accepted Answer · 2015-03-18 18:33:46Z

8

I ran into the same problem and found help here on the official website. Essentially, you can double-click on the sqlite3.exe file. Then use the .open command to get a persistent database. To create your testDB.db database, you can do as follows:

SQLite version 3.8.8.3 2015-02-25 13:29:11
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .open c:/sqlite/testDB.db
sqlite>

This should create testDB.db in c:/sqlite or some other folder you specify.

answered Mar 18, 2015 at 18:33

sedeh

7,3137 gold badges52 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Pedro P. Camellon Over a year ago

It did not work for me in Ubuntu 22: sqlite> .open ~/db.db Error: unable to open database "~/db.db": unable to open database file . >sqlite3 db.db did.

CL. · Accepted Answer · 2014-04-09 07:47:52Z

1

You do not need sqlite3.def or sqlite3.dll.
There are two ways if starting the sqlite3 command-line shell, either by double-clicking on the .exe, or by typing sqlite3 and any parameters in the Command Prompt. Do not try to start sqlite3 from inside itself.
SQLite Manager is able to create a new database.
Using a wrong path would not work.

answered Apr 9, 2014 at 7:47

CL.

182k18 gold badges241 silver badges282 bronze badges

Comments

Sumit Nautiyal · Accepted Answer · 2015-05-19 18:46:36Z

1

Reach the path where you want to start with SQLite through command prompt, for e.g. c:\sqlite>. Now when I use ls command I get
c:\sqlite>ls
sqlite3.exe
Now to create database type
c:\sqlite>sqlite3 database.db
It will create a database for you.

answered May 19, 2015 at 18:46

Sumit Nautiyal

774 bronze badges

Comments

Jonathan Freitas · Accepted Answer · 2015-09-02 22:59:09Z

0

Add sqlite3.exe in a folder, for example: C:\sqlite3\sqlite3.exe
Now go to the path where the sqlite3.exe is and run it.

answered Sep 2, 2015 at 22:59

Jonathan Freitas

613 bronze badges

Comments

Gavin V · Accepted Answer · 2021-12-25 10:06:14Z

0

Per the '.help' instructions, type '.save filename'. When reopening, type '.open filename'. This worked for me.

answered Dec 25, 2021 at 10:06

Gavin V

1

Collectives™ on Stack Overflow

Creating sqlite3 files/database

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related