Hello all,
I am working on a Java project which uses mysql for database. I want to design code for a data loading module which will define database schema and consume actual data. I want to know whether there is any way to run this load data infile command dynamically? I want pass these both files schema(database structure) and data file(*.csv,txt etc) as input parameters. Later, I want to run that command dynamically in Java environment. So has anyone encountered with such a challenge? Please advise. Thank you in advance.