MySQL Forums
Forum List  »  Newbie

null in blob column during inserting
Posted by: Paul Paulli
Date: March 28, 2020 06:49PM

I have table: mytable ( `id` bigint(20) NOT NULL AUTO_INCREMENT,`file` longblob).
When I try to insert by command: insert into mytable (file) value(LOAD_FILE('C:\myfolder\forder\images\chleb.jpg')) - it saved to table, but showed null in file column. I tried also: insert into mytable (file) value(LOAD_FILE('C:\\myfolder\\forder\\images\\chleb.jpg')), but showed the same. I use Windows. This file has 11kB. What should I do?

Options: ReplyQuote


Subject
Written By
Posted
null in blob column during inserting
March 28, 2020 06:49PM


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.