Opening database file from within SQLite command-line shell

Question

I'm using the SQLite Command Line Shell. As documented, I can open a database by supplying it as an argument to the executable:

sqlite3 data.db 

I cannot figure out how to open a database file from within the tool after having invoked it without supplying the file as a command-line argument (if I, say, double-click sqlite3.exe in Windows).

What is the command within the SQLite shell tool to specify a database file?

Answer 1

You can attach one and even more databases and work with it in the same way like using sqlite dbname.db

sqlite3 : sqlite> attach "mydb.sqlite" as db1; 

and u can see all attached databases with .databases

where in normal way the main is used for the command-line db

.databases seq  name             file                                                       ---  ---------------  ---------------------------------------------------------- 0    main                                                                        1    temp                                                                        2    ttt              c:\home\user\gg.ite                                    

Answer 2

I think the simplest way to just open a single database and start querying is:

sqlite> .open "test.db" sqlite> SELECT * FROM table_name ... ; 

Notice: This works only for versions 3.8.2+