LOAD DATA INFILE 'c:/users/amol/downloads/test_table.csv' INTO TABLE test_table FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS; \\JOIN\\ SELECT ttm.class_id, tsm.timeslot_from, tsm.timeslot_to, ttpm.weekday_id, ttpm.subject_id FROM timetable_master ttm INNER JOIN timetable_period_map ttpm ON ttm.timetable_id = ttpm.timetable_id INNER JOIN timeslot_master tsm ON tsm.timeslot_id = ttpm.timeslot_id WHERE ttm.class_id='201516_v_AM'