How to insert image in MySQL database using sql query?

This example example you will learn shows you the use of sql query to insert the data into mysql table.

How to insert image in MySQL database using sql query?

This example example you will learn shows you the use of sql query to insert the data into mysql table.

How to insert image in MySQL database using sql query?

Insert image in MySQL database using sql query

     

In this tutorial we have created a table in MySQL database and then used the query to insert the data into it. This tutorial teaches you to use the query to insert the data into database.

The video of this tutorial show you how you can insert the image into database and then see it using the MySQL editing tool.

Here is the video tutorial of "How to insert image in MySQL database using sql query?":

So, lets start:

Step 1: Create MySQL Table

We are creating a mysql table with a blob type field in it, so that we can save image in it.

In our table we have only two fields:

1) image_id of int type

2) image of blog type

Here is the query to create table:

CREATE TABLE pictures (
image_id int(10) NOT NULL auto_increment,
image blob,
PRIMARY KEY (`image_id`)
);

Step 2: insert image into table

Now we can insert the image into table using the insert into sql. Following is the example of sql:

INSERT INTO pictures VALUES(1, LOAD_FILE('d:\\flower.gif'));

We have used the LOAD_FILE() function of MySQL to insert the image data into database.

After inserting the data you can view it using the MySQL tool.

Check more tutorials at MySQL tutorials section.