我有个文件test.txt,里面有如下数据：
"5","abc"
"6","def"
"7","ghj"

然后我用如下方法导入
load data infile 'e://test.txt' replace into table testtable fields terminated by ',' enclosed by '"' lines terminated by '\n';
结果产生以下错误：
error 1262(01000):row 1 was truncated;it contained more data than there were input columns
请问是什么问题？
注:我的testtable定义如下
create table testtable
(id char(1) primary key,
sname char(10) not null)

[此贴子已经被作者于2007-9-5 20:12:20编辑过]