Store images in MySQL database

Question

I want to know how to store images and files in a MySQL database I want to get images and files like this www.example / rsrc.php / example-image.jpg

Facebook example: facebook-example.com/rsrc.php/v2/yw/r/svhh826BLKd.png

Answer 1

Create a BLOB column in the database table,

possibly average.

but it’s good to save the photo in a directory and save the path in the database. Greetings

CREATE TABLE tblname(ID INT,IMAGE BLOB); INSERT INTO tblname(ID,IMAGE) VALUES(1,LOAD_FILE('C:/test.txt')); 

added an answer from the comments on this question in the answer box.