How to insert image in mysql database(table)

Blog-38.jpg

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)?

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

id filename path
1jack.jpgpath/to/images/jack.jpg

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.

About the Author

Technical Content Writer | Software Developer

Nirnayika Rai is a Software Engineer and Technical Content Writer with experience in full-stack development, cloud platforms, and software systems. She creates clear, well-structured content that helps developers understand and apply technical concepts with confidence. Her work combines coding knowledge with a strong focus on clarity, accuracy, and practical relevance.

Intellipaat