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: Parameterexpression: It specifies a value to test if it is NULL value. Consider a table "officers" having the following data. ![]() Execute the following query: Output: ![]() Note: Here, you are getting the empty result because there is no NULL value in officer_name column.
Next TopicMySQL IS NOT NULL
|
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