load data
infile "c:\aa\aa.txt"
truncate into table orders_tmp
fields terminated by X'09'
(CUST_NBR ,
REGION_ID,
SALESPERSON_ID ,
YEAR ,
MONTH ,
TOT_ORDERS ,
TOT_SALES )
infile "c:\aa\aa.txt"
truncate into table orders_tmp
fields terminated by X'09'
(CUST_NBR ,
REGION_ID,
SALESPERSON_ID ,
YEAR ,
MONTH ,
TOT_ORDERS ,
TOT_SALES )