How to insert .csv data into mysql

Below coding you can paste in mysql query browser by specifying file location in infile and by specifying other attributes as below

LOAD DATA LOCAL INFILE 'H:\\Nipuna Docs\\test data employee.csv'

INTO TABLE erpsystem.employee FIELDS TERMINATED BY ','

ENCLOSED BY '"' LINES TERMINATED BY '\r\n' (empid,fname,mname,lname);