command to open an existing sqlite database

Question

i know the command to create a database in sqlite. i.e sqlite3 databasename.sqlite. But can anybody tell me what is the command to open an existing database in terminal. Please anybody help me

DarkDust · Accepted Answer · 2011-03-31 06:03:55Z

5

You simply use sqlite3 myExistingDatabase.sqlite.

answered Mar 31, 2011 at 6:03

DarkDust

92.7k19 gold badges199 silver badges231 bronze badges

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

2 Comments

Rocky Over a year ago

but i am having a doubt say my existing database name is test. if i write sqlite3 test.sqlite what does it mean am i creating a new database or opening an existing one .Because same is the syntax for creating a new database.

DarkDust Over a year ago

The behavior is simple and documented (for example in the man-page): if the filename exists it is opened. If it doesn't exist it is created first. If you're still afraid, just make a copy of the original database and try it.

Collectives™ on Stack Overflow

command to open an existing sqlite database

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related