How to load data of csv file in MySQL Database Table

Question

Hi,
I need to load many records from .csv file to MySql database table. Could you please suggest how can I do that? Please share the code.

Answer 1

You can do it using a code similar to the one mentioned below:

LOAD DATA LOCAL INFILE 'path/to/file/and/filename' INTO TABLE <table name> FIELDS TERMINATED BY "," ENCLOSED BY "" LINES TERMINATED BY "\n" IGNORE 1 ROWS;