MYsql 为何只load进去一条记录??

Question

我的data.txt如下:
130640164058,2010-09-25,4367420110929489985,,002,00:22:28,660246,INQ,0,00,11
130640164058,2010-09-25,6227000110350033080,,002,02:45:16,660251,CWD,1000,00,11
130640164058,2010-09-25,4367420110328201312,4367420110328179088,002,05:33:01,660254,TFR,1000,00,11
130640164058,2010-09-25,4367420110018416428,,002,08:39:17,660343,CWD,2000,00,11
130640164058,2010-09-25,4367420110018416428,,002,08:39:17,660343,CWD,2000,00,11
130640164058,2010-09-25,4367420110398207769,,002,07:59:21,660286,CWD,2500,00,11
130640164058,2010-09-25,4367420110398207769,,002,08:00:25,660288,CWD,2500,00,11
130640164058,2010-09-25,4367420110398207769,,002,07:59:53,660287,CWD,2500,00,11
130640164058,2010-09-25,4367420110398207769,,002,08:00:58,660289,CWD,2500,00,11
130640164058,2010-09-25,4367420110398207769,,002,08:01:30,660290,CWD,2500,00,11
130640164058,2010-09-25,4367420110398207769,,002,08:02:02,660291,CWD,2500,00,11
130640164058,2010-09-25,4367420110398207769,,002,08:02:34,660292,CWD,2500,00,11
130640164058,2010-09-23,4367420110148133448,,002,09:39:20,658805,CWD,2500,11,00
130640164058,2010-09-23,4367420110148133448,,002,09:40:47,658806,CWC,2500,00,00
130640164058,2010-09-18,4367420110388369561,,002,10:11:44,654262,CWD,2500,11,00
在MYSQL命令行输入:
load data local infile 'd:\data.txt' into table mx fields terminated by ',' LINES terminated by '\r\n';
提示Query OK,1 rows affected
    Records:15 Deleteed 0 Skipped 14 Warnings 0
查询后表里 只加进了第一条记录  什么原因???????

Answer 1

贴出你的 show create table tableName
然后上传一个测试用的文件。这样别人可以直接测试以找到问题所在。可以上传到 http://www.access911.net/csdn

Answer 2

130640164058,2010-09-25,4367420110929489985,,002,00:22:28,660246,INQ,0,00,11
--这里缺少数据，应该补全来，
130640164058,2010-09-25,6227000110350033080,,002,02:45:16,660251,CWD,1000,00,11
130640164058,2010-09-25,4367420110328201312,4367420110328179088,002,05:33:01,660254,TFR,1000,00,11
--导入成功的只有这一条，因为这一条数据正确
语句没问题。