将MySQL LOAD DATA INFILE与不可打印的字符定界符一起使用 [英] Using MySQL LOAD DATA INFILE with nonprintable character delimiters

问题描述

我有一些供应商数据，其中SOH(ASCII字符1)作为字段定界符，而STX(ASCII字符2)作为记录定界符.是否可以通过LOAD DATA INFILE加载该数据而无需预处理文件并将这些字符替换为更常见的字符?

I have some vendor data that has the SOH (ASCII character 1) as the field delimiter and STX (ASCII character 2) as the record delimiter. Is it possible to load this data with LOAD DATA INFILE without pre-processing the file and replacing those characters with something more common?

推荐答案

我明白了.

LOAD DATA LOCAL INFILE 'myfile.txt' INTO TABLE my_table 
    CHARACTER SET UTF8 
    FIELDS TERMINATED BY X'01'
    LINES TERMINATED BY X'02'
    (col1, col2, col3);

这篇关于将MySQL LOAD DATA INFILE与不可打印的字符定界符一起使用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！