unable to insert the image in MySQL

Question

I'm trying to insert the image in MySQL whenever i tried to add the image it showed null value. Pls help me to add the image. I've give the correct path but still error has occurred

create table image3(id int, image longblob not null);

insert into image3(id,image)values(571185, load_file('D:\Images\3.jpg'));

What is the error you are getting? – Bart Friederichs Jun 21 '16 at 06:51 — Bart Friederichs, Jun 21 '16 at 06:51
Try reversing the slashes. – Strawberry Jun 21 '16 at 06:54 — Strawberry, Jun 21 '16 at 06:54
The error is: Error Code: 1048. Column 'img' cannot be null – chozhan Jun 21 '16 at 08:17 — chozhan, Jun 21 '16 at 08:17

score -2 · Answer 1 · edited May 23 '17 at 10:33

-2

The function load_file() returns the string representation of the file (it only works with text files).

What you're trying to do is insert binary data.

EDIT I was wrong, disregard the answer, instead look at this one: Load_File doesn't work

EDIT 2 Could it be that you have to use / instead of \? I know windows uses \ for path separators, but it's quite frankly the only OS to do so. Therefore I can imagine that MySQL (being multiplatform) uses "the correct separators".

edited May 23 '17 at 10:33

Community

1
1

answered Jun 21 '16 at 06:56

ToVine

560
5
16

I doubt that. The docs (http://dev.mysql.com/doc/refman/5.7/en/string-functions.html#function_load-file) give an example with an image. – Bart Friederichs Jun 21 '16 at 07:00
My bad, withdrawing answer – ToVine Jun 21 '16 at 07:02

unable to insert the image in MySQL

1 Answers1