您可以指定列，并将不需要的列标记为“ @dummy”。
LOAD DATA INFILE 'data.csv'INTO TABLE t1(column1, @dummy, column2, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy, @dummy)FIELDS TERMINATED BY 't' ENCLOSED BY LINES TERMINATED BY 'rn'IGNORE 1 LINES;
替换
t1，
column1并且
column2只要你喜欢。要设置不在数据文件中的其他列，您可以这样做：
LOAD DATA INFILE 'data.csv'INTO TABLE t1(column1, @dummy, column2, @dummy, @val, @dummy, @dummy, @dummy, @dummy, @dummy)FIELDS TERMINATED BY 't' ENCLOSED BY LINES TERMINATED BY 'rn'IGNORE 1 LINESSET column3 = "test", column4 = CURRENT_TIMESTAMP, column5 = @val/10;
作为进一步的参考，我建议您看一下MySQL参考。
