LOAD DATA
INFILE 'list.txt'
APPEND INTO TABLE group_list
(groupno constant 'GC02000000018133',
memberno POSITION ( 1:6 ) INTEGER EXTERNAL,
idno POSITION ( 7:26 ) CHAR,
client_addr POSITION ( 27:86 ) CHAR,
client_name POSITION ( 87:146 ) CHAR,
grade_level POSITION ( 157:161) CHAR,
generate_flag POSITION ( 162:162) CHAR)list.txt文数据文件
INFILE 'list.txt'
APPEND INTO TABLE group_list
(groupno constant 'GC02000000018133',
memberno POSITION ( 1:6 ) INTEGER EXTERNAL,
idno POSITION ( 7:26 ) CHAR,
client_addr POSITION ( 27:86 ) CHAR,
client_name POSITION ( 87:146 ) CHAR,
grade_level POSITION ( 157:161) CHAR,
generate_flag POSITION ( 162:162) CHAR)list.txt文数据文件
infile 'd:\ckc\01.txt'
append into table STALL_ALL
fields terminated by ',' optionally enclosed by '"'
(
staff_id nullif(staff_id='#NULL#'),
num nullif(num='#NULL#'),
name nullif(name='#NULL#'),
gender_id nullif(gender_id='#NULL#'),
nation nullif(nation='#NULL#'),
birthday date "yyyy-mm-dd" enclosed by '#' and '#' nullif(birthday='NULL'),
politics nullif(politics='#NULL#'),
address nullif(address='#NULL#'),
post nullif(post='#NULL#'),
education_id nullif(education_id='#NULL#'),
school nullif(school='#NULL#'),
graduate_date date "yyyy-mm-dd" enclosed by '#' and '#' nullif(graduate_date='NULL'),
department nullif(department='#NULL#'),
job_date date "yyyy-mm-dd" enclosed by '#' and '#' nullif(job_date='NULL'),
account_job_date date "yyyy-mm-dd" enclosed by '#' and '#' nullif(account_job_date='NULL'),
title_id nullif(title_id='#NULL#'),
major_cert_id nullif(major_cert_id='#NULL#'),
tech_title_id nullif(tech_title_id='#NULL#'),
tech_title_date date "yyyy-mm-dd" enclosed by '#' and '#' nullif(tech_title_date='NULL'),
qualification nullif(qualification='#NULL#'),
qual_way nullif(qual_way='#NULL#'),
qual_date date "yyyy-mm-dd" enclosed by '#' and '#' nullif(qual_date='NULL'),
qual_depart nullif(qual_depart='#NULL#'),
qual_cert_id nullif(qual_cert_id='#NULL#'),
corp nullif(corp='#NULL#'),
corp_address nullif(corp_address='#NULL#'),
corp_telephone nullif(corp_telephone='#NULL#'),
corp_post nullif(corp_post='#NULL#'),
corp_economy_id nullif(corp_economy_id='#NULL#'),
account_cert_id nullif(account_cert_id='#NULL#'),
account_cert_date date "yyyy-mm-dd" enclosed by '#' and '#' nullif(account_cert_date='NULL'),
account_reg_date date "yyyy-mm-dd" enclosed by '#' and '#' nullif(account_reg_date='NULL'),
account_depart nullif(account_depart='#NULL#'),
ann_check_date date "yyyy-mm-dd" enclosed by '#' and '#' nullif(ann_check_date='NULL'),
acc_comp_cert_id nullif(acc_comp_cert_id='#NULL#'),
acc_comp_cert_num nullif(acc_comp_cert_num='#NULL#'),
acc_comp_cert_date date "yyyy-mm-dd" enclosed by '#' and '#' nullif(acc_comp_cert_date='NULL'),
acc_comp_cert_depart nullif(acc_comp_cert_depart='#NULL#'),
abacus_id nullif(abacus_id='#NULL#'),
abacus_cert_id nullif(abacus_cert_id='#NULL#'),
mount_acc_cert_num nullif(mount_acc_cert_num='#NULL#'),
mount_acc_cert_date date "yyyy-mm-dd" enclosed by '#' and '#' nullif(mount_acc_cert_date='NULL'),
mount_acc_cert_depart nullif(mount_acc_cert_depart='#NULL#'),
nomount_acc_cert_num nullif(nomount_acc_cert_num='#NULL#'),
nomount_acc_cert_date date "yyyy-mm-dd" enclosed by '#' and '#' nullif(nomount_acc_cert_date='NULL'),
nomount_acc_cert_depart nullif(nomount_acc_cert_depart='#NULL#'),
con_edu_id nullif(con_edu_id='#NULL#'),
con_edu_count_hour integer nullif(con_edu_count_hour='#NULL#'),
iswork nullif(iswork='#NULL#'),
enter_time position(*+2) date "yyyy-mm-dd hh24:mi:ss" enclosed by '#' and '#' nullif(nomount_acc_cert_date='NULL')
)