MySQL IS NOT NULL Condition
MySQL 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.
expression: It specifies a value to test if it is not NULL value.
MySQL IS NOT NULL Example
Consider a table "officers" having the following data.
Execute the following query:
Note: Here, you are getting the complete "officers" table as result because every value is NOT NULL in the table.
JavaTpoint offers too many high quality services. Mail us on [email protected], to get more information about given services.
JavaTpoint offers college campus training on Core Java, Advance Java, .Net, Android, Hadoop, PHP, Web Technology and Python. Please mail your requirement at [email protected]
Duration: 1 week to 2 week