装载字段固定长度的文件 一个例子: Load data infile ‘yyb_data.txt’ append Into table emp ( name position(1:10) char, rank position(11:13) interger external, birthday position(13:23) date “dd-mm-yyyy” ) 导入有界定符的文件 一个例子: Load data Infile ‘c:\yyb.txt’ append Into table emp ( name char terminated by ‘,’, rank interger external terminated by ‘,’, birthday date “dd-mm-yyyy” terminated by ‘,’ ) 导入有界定符的文件 (续) 再看一个例子(处理空字段): Load data Infile ‘c:\yyb.txt’ append Into table emp trailing nullcols ( name char terminated by ‘,’, rank interger external terminated by ‘,’, birthday date “dd-mm-yyyy” terminated by ‘,’ ) 如何把数据放到表中
验证码:
注册会员 会员登陆