Question

What is the benefit of MySQL ‘IS NULL’ and ‘IS NOT NULL’?

Answer 1

Answer: NOT NULL Constraint . By default , a column can hold NULL values . The NOT NULL constraint enforces a column to NOT accept NULL values .

Explanation: This enforces a field to always contain a value , which means that you cannot insert a new record, or update a record without adding a value to this field .