mysql导入csv文件语法

LOAD DATA INFILE '../10.csv' INTO TABLE user_score FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' lines terminated by '\r\n' ignore 1 lines (id,user_id,score,update_time,address,add_time);