In MySQL IS NULL operator is used to check for NULL value in the SELECT, INSERT, UPDATE, or DELETE statement. If expression is a NULL value, the condition evaluates to TRUE otherwise FALSE.
To check for the NULL value in the field, use the following syntax:
Parameters:
tablename: The table name from which you want to perform IS NULL
operator.
expression: To test specifies value if it is NULL value.
IS NULL
operator is used to check for the NULL value in the "address" field:
Note:
In the above example, we are performing IS NULL
operator to check for the NULL value in the "address" field.
You can use MySQL Command Line Client to perform IS NULL
operator to check for NULL value in the field. It will look like this: