有趣,2002-6-14日也是你们两个回答这类问题,也是这个次序。
不行,我把aaa.ctl改成:
load data
into table www
(
m char terminated by '|' ,
z char terminated by '|' ,
h char terminated by '|'
)
居然还是同样错误,我根本就没提到aaa.txt!
不行,我把aaa.ctl改成:
load data
into table www
(
m char terminated by '|' ,
z char terminated by '|' ,
h char terminated by '|'
)
居然还是同样错误,我根本就没提到aaa.txt!
load data
infile *
Append
into table www
trailing nullcols
(
m char terminated by '|' ,
z char terminated by '|' ,
h char terminated by '|'
)
begindata
1015555551030|脚后跟和环境和脚后跟|2555|
4522222222255|衣服容易反光镜|787|
......成功了。
为什么 infile 'aaa.txt' 就不行?
看来是每行结尾的回车符不被识别的问题
load data
infile 'aaa.txt'
the aaa.txt should be a seperated external .txt file include directory like C:\TEMP\aaa.txt;
Else if
you use the aaa.ctl like
load data
infile *
the txt file should be include in the .ctl file;
End;