Devart Forums

Dear DBForge Users:
I am running into a technical problem with one SQL statement. I am trying to update an Image field which is a Blob field with a picture. This is my SQL Statement:

UPDATE ehr_academic.`200_patient`
SET
pat_image = load_file('/ehr/images/ehr.jpg')
WHERE
patient_id = '1126999239468593';

Pat_Image is the Blob field and the image is ehr.jpg which resides in as http://localhost//ehr/images/ehr.jpg.
I could not update the blob field (Pat_image) with the image upon many tries. The output is:
Connection 'ehr_academic.localhost' was connected.
UPDATE Imageo.sql: 0 rows updated [7.802s]

I write about Health Informatics and have a paper talking about "Patient Privacy and HIPAA". I shall truly appreciate your help.

Dr. Sukhen Dey
[email protected]

We would suggest you to make sure whether the record where patient_id = '1126999239468593' exists in the table.