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

User · Accepted Answer

Please try below code  INSERT INTO xx BLOB ID IMAGE  VALUES 1 LOAD FILE  E  Images jack jpg

User · Answer

This is on mysql workbench -- give the image file path   INSERT INTO XX SAMPLE id image  VALUES 3   home ganesan-pc Documents aios database confe jpg

User · Answer

If I use the following query   INSERT INTO xx BLOB ID IMAGE   VALUES 1 LOAD FILE  E  Images xxx png       Error  no such function  LOAD FILE

User · Answer

You should use LOAD FILE like so   LOAD FILE   some path image png

User · Answer

Step 1  open your mysql workbench application select table  choose image cell right click select  Open value in Editor     Step 2  click on the load button  and choose image file   Step 3 then click apply button  Step 4  Then apply the query to save the image  Don t forgot image data type is  BLOB   Step 5  You can can check uploaded image

User · Answer

You can try something like this    CREATE TABLE  sample   picture      idpicture  INTEGER UNSIGNED NOT NULL AUTO INCREMENT    caption  VARCHAR 45  NOT NULL    img  LONGBLOB NOT NULL    PRIMARY KEY  idpicture    TYPE   InnoDB    or refer to the following links for tutorials and sample  that might help you   http   forums mysql com read php 20 17671 27914  http   mrarrowhead com index php page store images mysql php php  http   www hockinson com programmer-web-designer-denver-co-usa php s 47

User · Answer

I have three answers to this question    It is against user experience UX best practice to use BLOB and CLOB data types in string and retrieving binary data from an SQL database thus it is advised that you use the technique that involves storing the URL for the image  or any Binary file in the database   This URL will help the user application to retrieve and use this binary file  Second the BLOB and CLOB data types are only available to a number of SQL versions thus functions such as LOAD FILE or the datatypes themselves could miss in some versions  Third DON T USE BLOB OR CLOB  Store the URL  let the user application access the binary file from a folder in the project directory

User · Answer

I tried all above solution and fail  it just added a null file to the DB    However  I was able to get it done by moving the image fileName jpg  file first in to below folder in my case  C  ProgramData MySQL MySQL Server 5 7 Uploads and then I executed below command and it works for me   INSERT INTO xx BLOB ID IMAGE  VALUES 1 LOAD FILE  C  ProgramData MySQL MySQL Server 5 7 Uploads fileName jpg       Hope this helps

[mysql] How to insert image in mysql database(table)?

Examples related to mysql

Examples related to database

Examples related to blob

Examples related to mysql-loadfile