Bruno Raljić

A Java Developer's Blog

mysql

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 […]

, , ,

How to merge two MySQL databases manually [part 2]

Okay, here I will continue with my story about the database merging. In the second part, I’ll focus more on the technical stuff, how it is realized, how to get some values, how to execute some steps etc. The idea… After the discussion about the potential ways how to execute this migration, we agreed to […]

, ,