How to import CSV into SQLite3

       

To import a CSV file into SQLite is easy.

sqlite3 my.db
.mode csv
.import path/to/file.csv name_of_table

And done.

Tagged w/ #sqlite3 #sqlite #csv #importing

Apps I've Built

PhotoLocationChanger
Easily change the location on your photos and videos
Click here for more info about the app
PhotoDateChanger
Easily change the dates and times on your photos and videos
Click here for more info about the app
VocabReminder
English dictionary with notifications so you won't forget what you're studying!
Click here for more info about the app
VocabQuiz
The app that quizzes and scores you on your vocabulary!
Click here for more info about the app