Answer the question
In order to leave comments, you need to log in
How can I view a photo from a BLOB field from the MySQL 5.7 console?
Let there be a table:
CREATE TABLE Photo(
id INT NOT NULL PRIMARY KEY,
data MEDIUMBLOB);
INSERT INTO Photo VALUE(1, LOAD_FILE('D:/1.jpg'));
Answer the question
In order to leave comments, you need to log in
no way, mysql server does not interpret this as a picture in principle
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question