仅将CSV文件中的特定列加载到MySQL表中

我在将CSV文件中的数据插入MySQL时遇到问题。

我有不同类型的CSV文件，每个文件都有不同的列。但是，所有文件都包含一些公共列。我只需要从文件中读取选定的列。

示例CSV列

File 1: "Name","Mobile","Gender","Address","City","State"
File 2: "Name","Mobile","Distict","Operator","Address"
File 3: "Name","Mobile","Address"

我的MySQL表结构如下：

name | mobile | address

我正在使用以下方法：

LOAD DATA INFILE '/path/to/file' INTO TABLE example FIELDS TERMINATED BY ','
ENCLOSED BY '"' LINES TERMINATED BY ''r'n' (col1, col2, col3, ...);

我几乎没有错误，无法准确地加载数据。提前谢谢。