I
I
Ivan Melnikov2018-04-12 14:02:08
MySQL
Ivan Melnikov, 2018-04-12 14:02:08

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

A photo was written to it: How can I view this photo from the MySQL 5.7 console?
INSERT INTO Photo VALUE(1, LOAD_FILE('D:/1.jpg'));

Answer the question

In order to leave comments, you need to log in

2 answer(s)
L
Lazy @BojackHorseman MySQL, 2018-04-12
@immelnikoff

no way, mysql server does not interpret this as a picture in principle

A
AVKor, 2018-04-12
@AVKor

No way.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question