I have a CSV file that contains a lot of integer values. Is it better to insert these individual values in bulk as in a full transaction or should I be inserting the CSV file itself into the MySQL?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
migrated from stackoverflow.com Mar 20 '13 at 5:34
This question came from our site for professional and enthusiast programmers.
Insert the individual values in bulk. In other words, each row of the csv file should become a row in the database with the same number of columns.
Using Notepad++ you can use a regex find and replace to easily convert your CSV into a very large insert statement. Replace