This is a short note about how to import comma separated data, CSV, from a file into a mysql database from a shell.
load data infile '/home/username/data.csv' into table program fields terminated by ';' lines terminated by '\r\n';
Tags: csv, Database, import, MySQL
Posted by Hans-Henry Jakobsen