在年龄列上创建一个唯一索引,然后:
LOAD DATA INFILE 'member.csv'IGNORE INTO TABLE tbl_memberFIELDS TERMINATED BY ','ENCLOSED BY '"'ESCAPED BY '"'LINES TERMINATED BY 'n'(name, age);

在年龄列上创建一个唯一索引,然后:
LOAD DATA INFILE 'member.csv'IGNORE INTO TABLE tbl_memberFIELDS TERMINATED BY ','ENCLOSED BY '"'ESCAPED BY '"'LINES TERMINATED BY 'n'(name, age);