mySQL向表中导入csv文件 LOAD DATA LOCAL INFILE “data.csv” INTO TABLE my_table FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘"’ LINES TERMINATED BY ‘\r\n’ IGNORE 1 LINES; (此处忽略1行及表头)