|
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: 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: Output: 
Note: Here, you are getting the complete "officers" table as result because every value is NOT NULL in the table.
Next TopicMySQL BETWEEN
|
Please Share
Learn Latest Tutorials
Preparation
Trending Technologies
B.Tech / MCA
Javatpoint Services
JavaTpoint offers too many high quality services. Mail us on hr@javatpoint.com, to get more information about given services.
- Website Designing
- Website Development
- Java Development
- PHP Development
- WordPress
- Graphic Designing
- Logo
- Digital Marketing
- On Page and Off Page SEO
- PPC
- Content Development
- Corporate Training
- Classroom and Online Training
- Data Entry
Training For College Campus
JavaTpoint offers college campus training on Core Java, Advance Java, .Net, Android, Hadoop, PHP, Web Technology and Python. Please mail your requirement at hr@javatpoint.com.
Duration: 1 week to 2 week
Like/Subscribe us for latest updates or newsletter 
