- 论坛徽章:
- 0
|
请问如何导入该文件load from "D:\bl_acc_01_200601.txt" 到表 bl_acc中,
bl_acc_01_200601.txt内容格式如下;
01176292|414185|2197946|1130101|60711002|131|7.37|0.0|7.37|1.0|67.0|
01176293|414186|695124|1130101|60711003|131|9.79|0.0|9.79|1.0|89.0|
0145211|434460|483248|1130101|60711004|306|8.1|0.0|0.0|1.0|81.0|
01174970|413249|431186|1130101|60711005|131|8.36|0.0|8.36|1.0|76.0|
……
我写了一个不行 大家帮忙改一下
load from "D:\bl_acc_01_200601.txt" of del modified by coldel| method p (1, 2, 3, 4, 5, 6, 7, 8, 9,10,11) MESSAGES "D:\bl_acc.log" insert into db2admin.bl_acc(tele_no ,service_no ,service_seq,device_type,subject_id,contract_id,debit_id,credit_value,balance_value,sheet_value,time_value)
copy no indexing mode autoselect;
connect reset; |
|