How can i update if MYSQL [BLOB] is NULL

Question

How can i update if Image field in MYSQL is empty or no image is uploaded?

I tried this but doesnt update anything.

     UPDATE `db`.`ts126` SET `Image` = LOAD_FILE('C:\Users\user\Desktop\aa\bb\cc\placeholder.png') WHERE Image=""

Also i tried

    UPDATE `db`.`ts126`
   SET `Image` = 'C:\Users\user\Desktop\aa\bb\cc\placeholder.png'
 WHERE Image="" OR Image IS NULL

Which is without LOAD_FILE in this case it updates the images [BLOB - 64 B] but When i display the image using PHP code Nothing shows up

subject says "null". you can NOT test for null with =. try where image is null instead — Marc B
– Marc B, Commented Dec 3, 2015 at 21:53

Martin · Accepted Answer · 2015-12-03 21:53:11Z

1

Try:

UPDATE `db`.`ts126`
  SET `Image` = LOAD_FILE('C:\Users\user\Desktop\aa\bb\cc\placeholder.png')
WHERE Image="" OR Image IS NULL

answered Dec 3, 2015 at 21:53

Martin

6,7054 gold badges28 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

11 Comments

Kaka Over a year ago

Can i Update image field without LOAD_FILE something is wrong with this command and my database i tired using it several time but no luck

Martin Over a year ago

Are you sure your path is correct? What is the size of the file? Can you add SHOW CREATE TABLE db.ts126 and the result of SELECT @@max_allowed_bytes?

Kaka Over a year ago

the Size of the file is 27Kb and Limit is (Max: 131 kKiB) where do i add that code next to update command?

Kaka Over a year ago

I tried update all without Load_File and from PHP doesn't show the image and on mysql it shown me [BLOB - 64 B]

Martin Over a year ago

Sorry I'm not too clear on your problem. Can you update the question with the code you're running and the output?

|

Collectives™ on Stack Overflow

How can i update if MYSQL [BLOB] is NULL

1 Answer 1

11 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

11 Comments

Your Answer

Sign up or log in

Post as a guest

Related