Load Data from CSV into MySql Table

Search Unix Commands/Scripts

Help us in improving the repository. Add new commands/scripts through 'Submit Commands/Scripts ' link.

Submit Commands/Scripts

Unix Commands/Scripts

Sample 1. Load Data from CSV into MySql Table

USAGE



LOAD DATA LOCAL INFILE '<CSV_FILE_NAME>' INTO TABLE <TABLE_NAME> FIELDS TERMINATED BY '<FIELD_SEPARATOR>';



EXAMPLE



LOAD DATA LOCAL INFILE 'xyz.csv' INTO TABLE EMPLOYEE FIELDS TERMINATED BY ',';

_{Like Feedback load csv into mysql table csv to mysql}