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
This will create the SQLite database where your terminal window currently is, which is usually your user profile folder:
You can go to that folder by going to :
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