Bruno Raljić

A Java Developer's Blog

csv

How to create customized CSV files directly from MySQL query results

In one of my previous articles, I described how to import data from CSV file into MySQL and now I’ll show you how to export it into the CSV file directly, as a result of query execution. First, let’s start with the basics. Here is the syntax for creating CSV file with some optional parameters […]

, ,

Import data from CSV files into MySQL

When I got this task (importing data from csv into database) for the first time, my reaction was – “OK, I’ll transform the data into one big insert statement, with a bit help of regex and execute it”. And, indeed, I did it that way. Shortly after that, Nikola Cakarevic showed me how to import […]

, , ,