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)” »