How to dump CSV files to MySQL (the easy way)

Sometimes, the only option for dumping data into a database is using CSV files – they’re easy to use for non-technical people, they are a fairly efficient way of storing data and can be easily exported from Excel files.

There’s oneĀ huge problem with them, though…they’re a real pain in the arse to work with.

So, I decided to create a reliable, easy to use way for dumping CSV files, no matter how big or small, to a MySQL database. I will, however, show some alternatives along the way.

Continue reading “How to dump CSV files to MySQL (the easy way)” »