load data infile 'D:\\1.csv' into table dwell
fields terminated by ','
CHARACTER SET utf8
enclosed by '"'
lines terminated by '\r\n'
ignore 1 lines;
–CHARACTER SET :mysql字符集,一定要加上,免去乱码麻烦
–INTO TABLE :导入到哪个表
–FIELDS TERMINATED BY :以什么作为分割符
–ENCLOSED BY :被什么包围,比如“”
–LINES TERMINATED BY:这个windows与linux不同,以什么作为一行的结尾。
–IGNORE 1 LINES; 忽略第一行,如果首行是列名,不是数据