C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML
MySQL IS NULL ConditionMySQL 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: expression IS NULL Parameterexpression: It specifies a value to test if it is NULL value. Consider a table "officers" having the following data. Execute the following query: SELECT * FROM officers WHERE officer_name IS NULL; Output: Note: Here, you are getting the empty result because there is no NULL value in officer_name column.
Next TopicMySQL IS NOT NULL
|