[tprabhuit]

Hi,

I think this will be useful for you..

LOAD DATA LOCAL INFILE <FILE NAME WITH LOCATION>
INTO TABLE <TABLENAME>
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(FIELD1, FIELD2, FIELD3, ... FIELDn);

Regards,
Prabhu.T