Import from CSV File to MySQL

gistfile1.txt

-- Go the CSVs path and then connect to the MySQL Server
mysql --user=YOURUSER --password=YOURPASSWORD --host=localhost  --local-infile=1 YOURDATABASE
LOAD DATA LOCAL INFILE 'YOURFILENAME.csv'
        INTO TABLE YOURTABLE
        FIELDS TERMINATED by ','
        LINES TERMINATED BY '\n';