Re: load data infile and load_file
Maybe someone else needs this:
The issue was with eol characters. The blob path in the input file was on last "column" and took half of the Windows eol as part of the value(MySql default eol character is set to LF).
Setting the oel to \r\n in my statement solved this issue and everything is working now:
load data infile "file_path" into table table_name lines terminated by '\r\n' (column01, @blob_path) set column2=load_file(@blob_path);
Subject
Written By
Posted
Re: load data infile and load_file
August 31, 2016 08:09AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.