
复制LOAD DATA INFILE f:\TL_FUND_MMS_BATCH.txt BADFILE f:\BAD_TL_FUND_MMS_BATCH1.dat APPEND INTO TABLE tl_fund_mms_batch Fields terminated by ",数据识介绍
" Optionally enclosed by " trailing nullcols ( NUMBATCHSEQID , VC2BATCHNAME, VC2RESOURCEID, NUMCOUNTTOTAL , NUMCOUNTSUCS, NUMCOUNTLONG , NUMCOUNTFAILD , VC2BILLPATH, NUMCREATEUSERID , NUMSENDUSERID , NUMDEALFLAG, DATCREATETIME DATE "YYYY-MM-DD HH24:MI:SS", DATSENDTIME DATE "YYYY-MM-DD HH24:MI:SS" ) 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.
(责任编辑:数据库)