posted on 11:48 AM on Thursday 18 September 2014
I do a lot of data loading into MySQL and wanting to save myself time doing this, I wrote a Java command line application to read a input tab delimited text file and load it into MySQL. The program will scan the columns and determine the data type automatically which saves quite a fair bit of time. And the performance is much better than the other solutions which I used in the past.