加载转换成csv文件的excel数据到表中

load data local infile #{url} replace into table
    SAM_ORDERSIGN_EXCEL_TEMP
     fields terminated by ',' enclosed by '"'
      LINES TERMINATED BY #{linefeed}
    ignore 1 lines
    (CHANNEL_NAME,PURCHASE_NO, WAREHOUSELEVEL2, CHANNEL_SKU,PURCHASEORDER_QUANTITY,
    PURCHASE_PRICE,ACTUAL_QUANTITY,REQUISITION_NO,ORDER_NO,GOODS_MODEL,PRODUCTION_MATERIA,RESERVATION_ARRIVEDATE,
    CHANNEL_RECEIVE_DATE,RESERVATION_RECEIPTNO);

转载于:https://www.cnblogs.com/sikuaiwu/p/11357677.html