LOAD DATA into mySQL.

In some cases, you need to load data into mysql from a command line interface. There is a simple way to do it (linux):

mysql -e "LOAD DATA LOCAL INFILE '$PWD/myfile.csv' INTO TABLE mytable FIELDS TERMINATED BY ','" mydb -u myuser -p