Resolved: Modifying NOT NULL Constraints with Existing Data

Question

Hello,

I tried to modify the NOT NULL constraint of email_address field in customers table. Having one record with NULL email_address, MySQL thrown an error.

Suppose we have real data, is there a workaround that we can do to continue the NOT NULL constraint on email_address field?

Answer 1

Hi Carl!
Thanks for reaching out.

This error message 1138 is because you have already NULL values for the email_address column. Please, remove this record and then run the ALTER TABLE query.

Hope this helps.
Best,
Tsvetelin

Resolved: Modifying NOT NULL Constraints with Existing Data

Submit an answer

related questions