CSV文件导入数据库的sql

load data infile ‘E:/sqlResult_1482078.csv’
into table data10
fields terminated by ‘,’ optionally enclosed by ‘”’ escaped by ‘”’
lines terminated by ‘\r\n’;