- 之前ctl文件定义
点击(此处)折叠或打开
- LOAD DATA
- CHARACTERSET ZHS16GBK
- INFILE 'wxls.csv'
- APPEND
- INTO TABLE temp_import20171201
- FIELDS TERMINATED BY ","
- TRAILING NULLCOLS
- (TEL,
- RESELLER,
- PAPERS_NO,
- PRODUCT_NAME,
- TICKET_PRICE,
- CONSUME_TIME DATE "YYYY-MM-DD HH24:mi:ss",
- ORDER_NO
- )
导入数据
点击(此处)折叠或打开