title: Mysql: Not getting an error when updating a NOT NULL column to null
body: <p>Why does mysql accepts null data when updating a not null column and then converts the data to 0.</p>
  
  <p>I am expecting an error it just does not show up. How can I get an error if someone tries to update a not null column to null? I need it so I can rollback the transaction if I get an error.Is there any configuration needed within the database to do this? Thank you</p>
  
  <p><a href="https://i.stack.imgur.com/gB0Ed.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gB0Ed.png" alt="enter image description here"></a></p>