How to insert image in mysql database(table)?

Question

I need to insert an image into a table like:

 CREATE TABLE XX_SAMPLE(ID INT
                       ,IMAGE BLOB);

So can anyone help me out to insert an image into the above table?

Answer 1

You can try the below code for inserting an image:

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

Jump start your career in the field of SQL with this SQL Training course today!

Do check out the below MySQL tutorial video that will help you out in a better way: