· 8 years ago · Jan 12, 2018, 09:34 PM
1DROP TEMPORARY TABLE IF EXISTS tmp_import;
2
3CREATE TEMPORARY TABLE tmp_import (id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY);
4
5LOAD DATA LOCAL INFILE '/import.csv' INTO TABLE tmp_import
6FIELDS TERMINATED BY ','
7ENCLOSED BY '"'
8LINES TERMINATED BY 'rn'
9IGNORE 1 LINES;
10
11500,400,101,93,005,22
124,954,23434,123423432,44