Orcle 导入数据eurusd.ctl

load
infile "C://DAT_MT_EURUSD_M1_201201.txt"
infile "C://DAT_MT_EURUSD_M1_201202.txt"
infile "C://DAT_MT_EURUSD_M1_201203.txt"
infile "C://DAT_MT_EURUSD_M1_201204.txt"
infile "C://DAT_MT_EURUSD_M1_201205.txt"
infile "C://DAT_MT_EURUSD_M1_201206.txt"
infile "C://DAT_MT_EURUSD_M1_2002.txt"
infile "C://DAT_MT_EURUSD_M1_2003.txt"
infile "C://DAT_MT_EURUSD_M1_2004.txt"
infile "C://DAT_MT_EURUSD_M1_2005.txt"
infile "C://DAT_MT_EURUSD_M1_2006.txt"
infile "C://DAT_MT_EURUSD_M1_2007.txt"
infile "C://DAT_MT_EURUSD_M1_2008.txt"
infile "C://DAT_MT_EURUSD_M1_2009.txt"
infile "C://DAT_MT_EURUSD_M1_2010.txt"
infile "C://DAT_MT_EURUSD_M1_2011.txt"

append into table EURUSD
fields terminated by ","
trailing nullcols
(
DATES ,
TIMES,
OPINET1,
OPINET2,
OPINET3,
OPINET4,
STATUS
)

转载于:https://www.cnblogs.com/adolfmc/archive/2013/06/03/3114631.html