Category Archives: CSV

CSV import for MySQL and MongoDB

1. For MySQL LOAD DATA INFILE ‘xxxxx_csv_file’ INTO TABLE table_name FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘”‘  LINES TERMINATED BY ‘\r\n’ IGNORE 1 LINES; * create the table_name table. * make sure to copy the csv file to /var/lib/mysql/db_name/ with correct permission … Continue reading

Posted in CSV, MongoDB | Tagged , | Leave a comment