How to insert image in mysql database(table)?

Question

I want to insert image into a table like

 CREATE TABLE XX_SAMPLE(ID INT
                       ,IMAGE BLOB);

So can you help out form how to insert image into the above table.

Answer 1

Please try below code

INSERT INTO xx_BLOB(ID,IMAGE) VALUES(1,LOAD_FILE('E:/Images/jack.jpg')); 

Answer 2

You should use LOAD_FILE like so:

LOAD_FILE('/some/path/image.png')