#---------导入前 打开允许导入文件权限; set global local_infile = 'ON'; #---------导入语句; load data local infile 'd:/Wip.csv' replace into table needs.wip_new fields terminated by ',' optionally enclosed by '"' lines terminated by '\r\n' ignore 1 lines;