LOAD DATA
INFILE 'd:\jypm\data\mis5.dat'
append INTO TABLE MIS5 when (load_values<>0 and tagname='Ballmill1') or (load_values=0 and tagname='Ballmill2')
( load_date POSITION(01:08) CHAR ,
load_time POSITION(09:12) CHAR ,
tagname POSITION(17:36) CHAR ,
load_values POSITION(37:46) INTEGER EXTERNAL )
INFILE 'd:\jypm\data\mis5.dat'
append INTO TABLE MIS5 when (load_values<>0 and tagname='Ballmill1') or (load_values=0 and tagname='Ballmill2')
( load_date POSITION(01:08) CHAR ,
load_time POSITION(09:12) CHAR ,
tagname POSITION(17:36) CHAR ,
load_values POSITION(37:46) INTEGER EXTERNAL )
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货