How to insert image in mysql database(table)

To insert image in the MySQL database(table), we have to use INSERT query. In this blog, we will learn how to insert images in MySQL database in more detail:

Table of Content:

• How to insert image in MySQL database(table)?
  • Syntax
  • Query
  • Output
• Conclusion

How to insert image in MySQL database(table)?

We can insert images in MYSQL databases. MySQL is a high-performance database management system far faster than its competitors.  MySQL is a client-based database. to insert an image in MYSQL database, we have to use some INSERT query.

Let’s learn with an example:

Syntax

INSERT INTO images (image) VALUES ('imgContent');

Where, images is the name of the table and imgContent is the name of the image file.

Query

CREATE TABLE images (
    id INT AUTO_INCREMENT PRIMARY KEY,
    filename VARCHAR(255),
    path VARCHAR(255)
);

INSERT INTO images (filename, path) VALUES ('jack.jpg', '/path/to/images/jack.jpg');

Output

Conclusion

So far in this article, we have learned how we can insert an image into a table in MYSQL. MySQL is an open-source, widely known relational database management system (RDBMS), known for being reliable, scalable, and of high performance. If you want to learn more about SQL and gain some certification in it, please have a look at our SQL course.