The goal is to build up a useful repository of objective-c code focusing on iOS implementations. Feel free to use what you need and, of course, suggest better, more efficient approaches.
Thursday, January 12, 2012
SQLite import from .csv file
Here are the quick and easy steps to import the contents of a .csv file into your SQLite3 database.
Open the db via the command line:
sqlite3 myDatabaseName
Enter the following commands:
.separator ","
.import myFile.csv tblMyTable
And that's it. If your .csv file has a different separator character, just replace the comma with your character.
So if I have a mySQL database and I export it using a util like PHPMyAdmin into a CSV file, I can import it into SQLite this easily?? Would I have to pre-set up the tables in SQLite first?
So if I have a mySQL database and I export it using a util like PHPMyAdmin into a CSV file, I can import it into SQLite this easily?? Would I have to pre-set up the tables in SQLite first?
ReplyDelete