Import CSV file with Mysql CLI

importCSV.sql

-- This following script / snippets can be used for import CSV file directly into MySQL
-- Advantages : very very fast (15.000.000 lines --> ~5min)


-- First use mysql cli binary with local-infile flag
-- mysql --local-infile -uThisisusername -pGreatPassword database

-- Clear table if you need to
TRUNCATE TABLE big_tables_numbers;


-- Now the magics lines

set autocommit = 0;
set unique_checks = 0;
set foreign_key_checks = 0;
set sql_log_bin=0; 
LOAD DATA LOCAL INFILE 'MY_BIG_FILE.csv' INTO TABLE big_tables_numbers  
FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' IGNORE 1 LINES (ID,FIRST_COL,S_COL,OTHER_COL,AGAIN,MORE,INFINITE,NO_END,HELL,PARADISE,WHY_NOT);
commit;
set autocommit = 1;
set unique_checks = 1;
set foreign_key_checks = 1;
set sql_log_bin=1;