C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML
MySQL IS NOT NULL ConditionMySQL IS NOT NULL condition is used to check the NOT NULL value in the expression. It is used with SELECT, INSERT, UPDATE and DELETE statements. Syntax: expression IS NOT NULL Parameterexpression: It specifies a value to test if it is not NULL value. MySQL IS NOT NULL ExampleConsider a table "officers" having the following data. Execute the following query: SELECT * FROM officers WHERE officer_name IS NOT NULL; Output: Note: Here, you are getting the complete "officers" table as result because every value is NOT NULL in the table.
Next TopicMySQL BETWEEN
|