Mysql judges whether the field is null

Mysql method to determine whether it is null: 1. Use the syntax “WHERE filed IS NULL” to query whether the field is empty; 2. Use the syntax “WHERE field IS NOT NULL” to query whether the field is not empty NULL.

Recommendation: “Mysql Video Tutorial”

MySQL judges whether the field is NULL

Problem

When using the MySQL database to determine whether the value of a field is NULL:

There is an exception when using field == NULL

Using field != NULL Exception

Solution

MySQL query field is empty NULL syntax

  WHERE filed IS NULL

MySQL query field is not empty NULL syntax

WHERE field IS NOT NULL

The above is the detailed content of mysql judging whether the field is null. For more information, please pay attention to other related articles on 1024programmer.com!