Hi, We are using Load data local infile command very frequently. when run on mysql prompt it throws following summary output
Query OK, 676446 rows affected (25.61 sec)
Records: 676446 Deleted: 0 Skipped: 0 Warnings: 0
I have started executing that mysql load data query from java But from java code, i do not know how to capture following mysql output and display it on screen.
Query OK, 676446 rows affected (25.61 sec)
Records: 676446 Deleted: 0 Skipped: 0 Warnings: 0
i tried return value of statement.executeupdate() but it returns only affected row count but does not give deleted, skipped and warninng count.
Do let me know if any other way to capture output by using any java utility or by executing some more mysql command like for warning we are executing select count(*) from warning or show warning
Same way if we can get deleted count and skipped count of Load data command then it will be good.