Technology
Importing CSV Data into MySQL
Once you have created the table, from the mySQL command prompt use: LOAD DATA LOCAL INFILE ‘/path/to/csv/file.csv’ INTO TABLE table_name FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘\”‘ LINES TERMINATED BY ‘\r\n’ (col1,col2,…); Once imported, […]