在mysql中新建一个表格,各个字段名字写好,然后
load data local infile '/home/username/source_data/cus_information.csv'
into table table_name
character set utf8
fields terminated by ','
lines terminated by '\r\n'
ignore 1 lines;
可能出现的问题:
–1.字段不对应,字段有null值的格式不对;
–2.编码问题,将csv编码格式转换为utf-8,记事本打开另存为可以改变;
–3.没有忽略第一行的字段名