load data
infile 'E:\Netage\JPOS\interface\displayDataPDA\DK.csv'
truncate into table chkdisp_tmp1
when (2)!='TAKEN_BY' fields terminated by ',' OPTIONALLY ENCLOSED BY '"'
(
INV_NO ,
TERM_ID ,
BARCODE ,
STOCK ,
SHELF ,
TAKEN_BY ,
"DATE" ,
TIME
)
请问下,这里是将csv文件的数据插入到chkdisp_tmp1一个表中,能不能同时再插入到一个chkdisp中呢?就在这段处理
infile 'E:\Netage\JPOS\interface\displayDataPDA\DK.csv'
truncate into table chkdisp_tmp1
when (2)!='TAKEN_BY' fields terminated by ',' OPTIONALLY ENCLOSED BY '"'
(
INV_NO ,
TERM_ID ,
BARCODE ,
STOCK ,
SHELF ,
TAKEN_BY ,
"DATE" ,
TIME
)
请问下,这里是将csv文件的数据插入到chkdisp_tmp1一个表中,能不能同时再插入到一个chkdisp中呢?就在这段处理
load data
infile 'E:\Netage\JPOS\interface\displayDataPDA\DK.csv'
truncate into table chkdisp_tmp1
when (2)!='TAKEN_BY' fields terminated by ',' OPTIONALLY ENCLOSED BY '"'
(
INV_NO ,
TERM_ID ,
BARCODE ,
STOCK ,
SHELF ,
TAKEN_BY ,
"DATE" ,
TIME
)
into table chkdisp
when (2)!='TAKEN_BY' fields terminated by ',' OPTIONALLY ENCLOSED BY '"'
(
INV_NO ,
TERM_ID ,
BARCODE ,
STOCK ,
SHELF ,
TAKEN_BY ,
"DATE" ,
TIME
)
另外,truncate是清空原表 慎用
load data
infile 'E:\Netage\JPOS\interface\displayDataPDA\DK.csv'
truncate into table chkdisp_tmp1
when (2)!='TAKEN_BY' fields terminated by ',' OPTIONALLY ENCLOSED BY '"'
(
INV_NO ,
TERM_ID ,
BARCODE ,
STOCK ,
SHELF ,
TAKEN_BY ,
"DATE" ,
TIME
)
into table chkdisp
(
…………
)