Cheap VPS & Xen Server

Residential Proxy Network - Hourly & Monthly Packages

MySQL IS NULL


MySQL IS NULL condition is used to check if there is a NULL value in the expression. It is used with SELECT, INSERT, UPDATE and DELETE statement.

Syntax:

  1. expression IS NULL

Parameter

expression: It specifies a value to test if it is NULL value.

Consider a table “officers” having the following data.

mysqlisnull1

Execute the following query:

  1. SELECT *
  2. FROM officers
  3. WHERE officer_name IS NULL;

Output:

mysqlisnull2

Note: Here, you are getting the empty result because there is no NULL value in officer_name column.

 

Comments

comments