我使用LOAD DATA INFILE 语法导入CSV的档案,档案资料数有871797笔资料,但是使用此语法导入,只有导入862500笔资料,曾担心是862500笔资料格式有错误,导致862501笔资料无法汇入,所以我尝试将CSV挡案中的前10笔资料删除,但是一样是导入862500笔资料,所以应该是某部分被限制住了,麻烦各位帮忙解决一下,或是有其他快速导入的方法也可以,感恩~Mysql在导入之后显示的讯息,it contained more data than there were input columns Records: 871797 Deleted: 0 Skipped: 0 Warnings: 0 6.951 sec.语法:LOAD DATA LOCAL INFILE '/Users/xxx/Documents/ChangeData/test123.csv' INTO TABLE test.test1 FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r'
我使用LOAD DATA INFILE 语法导入CSV的档案,档案资料数有871797笔资料,但是使用此语法导入,只有导入862500笔资料,曾担心是862500笔资料格式有错误,导致862501笔资料无法汇入,所以我尝试将CSV挡案中的前10笔资料删除,但是一样是导入862500笔资料,所以应该是某部分被限制住了,麻烦各位帮忙解决一下,或是有其他快速导入的方法也可以,感恩~Mysql在导入之后显示的讯息,it contained more data than there were input columns Records: 871797 Deleted: 0 Skipped: 0 Warnings: 0 6.951 sec.语法:LOAD DATA LOCAL INFILE '/Users/xxx/Documents/ChangeData/test123.csv' INTO TABLE test.test1 FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r'
create table test.test1 (ID char(10), CodeA char(10), CodeB char(8), 出生日期char(10), 性别char(1), 血型char(1), 血型char(2), 居住地区char(3), 身高char(3), 体重char(3), Date char(7), CodeC char(5), CodeD char(5), Code1 char(10), Code2 char(10), Code3 char (10),Code4 char(10) , Code5 char(10));
刚刚把我所有char内的值给成50,居然导入数据变成762XXX,Mysql跳出arning(s): 1366 Incorrect string value: '\xB0\xA9\xAC\xEC\xB3\xA1' for column 'ICD9_Code1' at row 1 1262 Row 1 was truncated;这个讯息!可是我已经把mysql设定UTF-8了!
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
Code内会有英文! !
再麻烦大家了,感恩!