Tuesday 21 January 2014

How to load excel data to Database using query




LOAD DATA LOCAL INFILE 'D:/MyWork/Master.csv' 
INTO TABLE Master COLUMNS TERMINATED BY ',';