I'm developing a Java swing application with back end Database MySQL . I've a screen to upload my datas to the Database using the Query like
LOAD DATA local INFILE 'D:\\TEMP\\import\\jan_jun2013.txt' INTO TABLE slsdata FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' IGNORE 1 LINES;
Here the datas are like from January to June. But if i want to skip any month data or to upload only a particular month then how will i modify the above query ?
In my database table , the date column is 'SLDATE'.
The Same question i've asked in some other forum's, but i'm not able to get any suggestions there!
Any suggestions please.?