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?
Mysql – Using MySQL LOAD DATA INFILE with nonprintable character delimiters
delimiterload-data-infileMySQLnon-printable
Related Topic
- Mysql – How to get a list of user accounts using the command line in MySQL
- Php – How to do ‘insert if not exists’ in MySQL
- MySQL load data infile – acceleration
- Python – thesql LOAD DATA INFILE with auto-increment primary key
- Mysql – How to import CSV file into a MySQL table
- Mysql – How to import an SQL file using the command line in MySQL
Best Answer
I got it.