It would not be better but simpler, because you can automate the task with an etl tool, thus allowing you to run the task on a user-defined basis.

Indeed, if it is a one-shot project, the fastest way to do it is indeed with :

LOAD DATA INFILE 'path/file.csv' INTO TABLE your_table;

However, if you plan on doing it on a regular basis (if...

Hi kei,

As a matter of fact you have two ways to do it depending on your technical background. You can either write a script yourself or use an ETL tool that will write the most part of the script...

Buddylee is right when he says that you shouldn't go for oracle if you intend to do a small project.

As a matter of fact there are benchmarks which shows that mysql offers almost the same...