LOAD DATA LOCAL INFILE "D:\\2018.CSV" //文件名
INTO TABLE dtone// 表名
FIELDS TERMINATED BY ',' //所采用的分隔符
OPTIONALLY ENCLOSED BY '”’//字符串所采用的“”区分
LINES TERMINATED BY "\r\n" //每一行用换行符(\n)用回车(\r)
因为是CSV文件要注意所采用的分隔符,和文件所采用的编码方式。
LOAD DATA LOCAL INFILE "D:\\2018.CSV"
INTO TABLE dtone
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '”’
LINES TERMINATED BY "\r\n"