79605716

Date: 2025-05-04 14:40:26
Score: 1
Natty:
Report link

You are getting error because your -storing BLOB NOT NULL- column has no default value, so MYSQL refuse to do.

INSERT INTO `cover` (id) VALUES (…);
there’s no value for storing and no default to fall back on.

You have a simple ways to fix it:
1. Allow NULL (or give it a DEFAULT NULL)

If you don’t mind that a newly-inserted row comes in with no image yet, alter the column to accept NULL:

"ALTER TABLE cover MODIFY storing BLOG NULL DEFAULT NULL";

After that, your INSERT INTO cover (id) VALUES (…) will work, and you can UPDATE … SET storing = … later.

Reasons:
  • Long answer (-0.5):
  • No code block (0.5):
  • Low reputation (1):
Posted by: Hemang Gandhi