Home
MySQL
SQL
PL/SQL
MongoDB
PostgreSQL
SQL Server
Oracle
SQLite
Cassandra
DBMS
Python
Java
Aptitude
Interview Q

MySQL Tutorial

MySQL Tutorial MySQL Features MySQL Versions MySQL Data Types MySQL Variables Install MySQL MySQL Connection

MySQL Workbench

User Management

MySQL Create User MySQL Drop User MySQL Show Users Change User Password

MySQL Database

MySQL Create Database MySQL Select Database MySQL Show Databases MySQL Drop Database MySQL Copy Database

Table & Views

MySQL CREATE Table MySQL ALTER Table MySQL Show Tables MySQL Rename Table MySQL TRUNCATE Table MySQL Describe Table MySQL DROP Table MySQL Temporary Table MySQL Copy Table MySQL Repair Table MySQL Add/Delete Column MySQL Show Columns MySQL Rename Column MySQL Views MySQL Table Locking MySQL Account Lock MySQL Account Unlock

MySQL Queries

MySQL Queries MySQL Constraints MySQL INSERT Record MySQL UPDATE Record MySQL DELETE Record MySQL SELECT Record MySQL Replace Insert On Duplicate Key Update MySQL INSERT IGNORE Insert Into Select

MySQL Indexes

MySQL Create Index MySQL Drop Index MySQL Show Indexes MySQL Unique Index MySQL Clustered Index MySQL Clustered vs Non-Clustered Index

MySQL Clauses

MySQL WHERE MySQL DISTINCT MySQL FROM MySQL ORDER BY MySQL GROUP BY MySQL HAVING

MySQL Privileges

MySQL Grant Privilege MySQL Revoke Privilege

Control Flow Function

MySQL IF() MySQL IFNULL() MySQL NULLIF() MySQL CASE MySQL IF Statement

MySQL Conditions

MySQL AND MySQL OR MySQL AND OR MySQL Boolean MySQL LIKE MySQL IN MySQL ANY MySQL Exists MySQL NOT MySQL Not Equal MySQL IS NULL MySQL IS NOT NULL MySQL BETWEEN

MySQL Join

MySQL JOIN MySQL Inner Join MySQL Left Join MySQL Right Join MySQL CROSS JOIN MySQL SELF JOIN MySQL DELETE JOIN MySQL Update Join MySQL EquiJoin MySQL Natural Join Left Join vs Right Join MySQL Union vs Join

MySQL Key

MySQL Unique Key MySQL Primary Key MySQL Foreign Key MySQL Composite Key

MySQL Triggers

MySQL Trigger MySQL Create Trigger MySQL Show Trigger MySQL DROP Trigger Before Insert Trigger After Insert Trigger MySQL BEFORE UPDATE Trigger MySQL AFTER UPDATE Trigger MySQL BEFORE DELETE Trigger MySQL AFTER DELETE Trigger

Aggregate Functions

MySQL Aggregate Functions MySQL count() MySQL sum() MySQL avg() MySQL min() MySQL max() MySQL GROUP_CONCAT() MySQL first() MySQL last()

MySQL Misc

MySQL Comments MySQL CHECK CONSTRAINT Change Storage Engine Export & Import Database Import CSV File in Database Export Table to CSV MySQL Subquery MySQL Derived Table MySQL UUID LEAD And LAG Function MySQL CTE MySQL On Delete Cascade MySQL UPSERT MySQL Commands Cheat-Sheet MySQL Transaction MySQL Partitioning MySQL ROW_NUMBER() MySQL Cursor MySQL Limit MySQL Stored Function MySQL Signal Resignal Number Format Function MySQL Ranking Functions MySQL Window Functions MySQL Union Union vs Union All MySQL VARCHAR MySQL ENUM MySQL SET MySQL DECIMAL MySQL CAST MySQL Convert() MySQL COALESCE() MySQL Wildcards MySQL Alias MySQL Functions MySQL ROLLUP MySQL INT MySQL Today MySQL ROW COUNT Prepared Statement MySQL Literals(Constants) MySQL Date & Time MySQL Procedure MySQL Minus MySQL Intersect MySQL Storage Engines MySQL Explain MySQL Sequence MySQL JSON MySQL Standard Deviation How to select nth Highest Record Find Duplicate Records Delete Duplicate Records MySQL Select Random Records MySQL Extract MySQL ProcessList MySQL BIT Change Column Type MySQL Reset Auto-Increment MySQL Interval Login with Different User How to Change Root Password in MySQL How to Clear MySQL Command Line Change Table Name In MySQL How to Connect to MySQL Add Auto Increment to Existing Column in MySQL How to Add Data to MySQL Database How to Comment in MySQL Delete all Data from Table MySQL How to Check Database in MySQL How to Delete a Row in MySQL How to Insert Multiple Rows in MySQL How To Insert Values in MySQL How to use MySQL Trigger How to use MySQL Before Trigger How to use MySQL After Trigger

MySQL Globalisation

MySQL Character Set MySQL Collation

Regular Expressions

Regular Expressions MySQL RLIKE Not Like Operator Not regexp Operator regexp Operator regexp_instr() Function regexp_like() Function regexp_replace() Function regexp_substr() Function

FULLTEXT Search

MySQL Fulltext Search Natural Language Fulltext Search Boolean Fulltext Search Query Expansion Fulltext Search ngram Fulltext Parser

Differences

MySQL vs MongoDB MySQL vs MS SQL Server MySQL vs Oracle MariaDB vs MySQL PostgreSQL vs MySQL MySQL vs SQL Table vs View Delete vs Truncate Command Database vs Schema Primary Key vs Foreign Key Primary Key vs Unique key Primary Key vs Candidate Key

Interview Questions

MySQL Interview SQL Interview PL/SQL Interview

next → ← prev

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.

Syntax:

Parameter

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:

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

← prev next →

For Videos Join Our Youtube Channel: Join Now

Feedback

Send your Feedback to [email protected]

Help Others, Please Share

Learn Latest Tutorials

Splunk

SPSS

Swagger

Transact-SQL

Tumblr

ReactJS

Regex

Reinforcement Learning

R Programming

RxJS

React Native

Python Design Patterns

Python Pillow

Python Turtle

Keras

Preparation

Aptitude

Reasoning

Verbal Ability

Interview Questions

Company Questions

Trending Technologies

Artificial Intelligence

AWS

Selenium

Cloud Computing

Hadoop

ReactJS

Data Science

Angular 7

Blockchain

Git

Machine Learning

DevOps

B.Tech / MCA

DBMS

Data Structures

DAA

Operating System

Computer Network

Compiler Design

Computer Organization

Discrete Mathematics

Ethical Hacking

Computer Graphics

Software Engineering

Web Technology

Cyber Security

Automata

C Programming

C++

Java

.Net

Python

Programs

Control System

Data Mining

Data Warehouse

^{Like/Subscribe us for latest updates or newsletter}

Learn Tutorials

Learn Java Learn Data Structures Learn C Programming Learn C++ Tutorial Learn C# Tutorial Learn PHP Tutorial Learn HTML Tutorial Learn JavaScript Tutorial Learn jQuery Tutorial Learn Spring Tutorial

Interview Questions

Java Interview Questions SQL Interview Questions Python Interview Questions JavaScript Interview Questions Angular Interview Questions Selenium Interview Questions Spring Boot Interview Questions HR Interview Questions C++ Interview Questions Data Structure Interview Questions

About

Javatpoint is developed to help students on various technologies such as Artificial Intelligence, Machine Learning, C, C++, Python, Java, PHP, HTML, CSS, JavaScript, jQuery, ReactJS, Node.js, AngularJS, Bootstrap, XML, SQL, PL/SQL, MySQL etc.

Javatpoint provides tutorials with examples, code snippets, and practical insights, making it suitable for both beginners and experienced developers.

There are also many interview questions which will help students to get placed in the companies.

Contact

Address: G-13, 2nd Floor, Sec-3

Noida, UP, 201301, India

Contact No: 0120-4256464, 9990449935