use work;
update applicants
set photo = (load_file("C:\Users\CEO\Pictures\MY PHOTOS\OT.jpg"))
where ID = 2001;
When I execute the query in MySQL workbench, it runs successfully, displaying 0 row(s) affected Rows matched: 1 Changed: 0 Warning
But when I decide to view my table records, the value under the photo column in ID 2001 row is NULL
I think my file name is supposed to show in my photo column instead of null.
I have made several researches to see and even changed my code to set photo = OT.jpg, using only the file name but it's still not working.
My photo datatype is BLOB, the size of my photo is 997kb
Please kindly assist me with the right STEPS if you can. I want the procedure STEP BY STEP to resolve this please.
I expect my records to show the values and my photo value to be my file name, it shouldn't be showing NULL again on the displayed table record in mysql workbench and command line