https://cloud.tencent.com/developer/ask/30313
mysql load csv 部分列指定列:
LOAD DATA LOCAL INFILE ‘data.csv’ INTO TABLE t
FIELDS TERMINATED BY ‘,’ LINES TERMINATED BY ‘\n’
(@col1,@col2,@col3,@col4) set name=@col2,id=@col4 ;
@col1,@col2,@col3,@col4是保存CSV文件列的变量,id是表列。