Creating SQLite3 Database on Mac

Question

I apologize for the extremely noobish quesetion, though I could not understand the answer provided here: Where is SQLite database stored on disk?. When creating a table within the SQLite3 shell via these commands as suggested here (Bulk load data into sqlite?):

 sqlite3 myDatabase
 create table myTable (a, b, c);
 .separator ','
 .import  myFile  myTable

I was not able to determine where "myDatabase" is actually saved to. Could someone please help me understand which folder it is typically saved to on a Mac, or how I could specify a folder to save it to.

Thanks so much for your help and patience

It is saved to the "current working directory" (unless other path information is supplied in the filename). This should be the directory you were in the shell which launched sqlite3. See "cd", "cwd" and "ls" commands. — user2246674
– user2246674, Commented Jul 22, 2013 at 22:17

Khattab · Accepted Answer · 2013-07-22 22:22:13Z

7

This will create the SQLite database where your terminal window currently is, which is usually your user profile folder:

enter image description here

You can go to that folder by going to :

enter image description here

answered Jul 22, 2013 at 22:22

Khattab

7371 gold badge10 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

Creating SQLite3 Database on Mac

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related