[求助]问个Mysql数据导入的问题
我有个文件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编辑过]