I want someone who has worked with mySQL bulk loader using "Load Data Infile" syntax, where the infile is a tab delimited txt file.
You can find detail about the Load-Data-Infile at this mySQL url
<[url removed, login to view]>
1) Please create a mySQL table with atleast
? ? ? ? ? ? ? ? 1 column auto increment
? and 1 column decimal
? and 1 column integer
? and 1 column datetime
? and 1 column variable character
? and 1 column character
The input tab delimited file should contain atleast 10 records that should loaded successfully. The datatime value value should have datetime not just date.
2) Secondly, I would need a .bat file, by running which I would be able to execute this process. As first step, the bat file will login to mySQL, process the Load Data Infile, and then logout.
This must run in Windows.