MySQL Forums
Forum List  »  Newbie

Re: load data infile and load_file
Posted by: Cristian Badoi
Date: August 31, 2016 08:09AM

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);

Options: ReplyQuote


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.