Question

How can we check for NULL in a MySQL query?

Answer 1

Answer:

MYSQL query to check for NULL.

Explanation:

MYSQL is the relational database that is used to store the data into the database. To find the NULL value in the table there is a query that can be used to extract the null value from the database. The query is:-

Select * from < table-name > where  <column-name > is null;

In which the table name consists of the name of the table where the column name contains the specific name of the column to search the NULL value into it. The query will execute and compare the column data with the null value if found then it fetches all the columns from the table which contain the null value.