AnalyzeCode

Analyze Code

Page Index

DBMS Introduction

What is DBMS ?
Types of Database
What is RDBMS ?
DBMS vs RDBMS
DBMS vs File System
DBMS Architecture
RDBMS 12 Codd's Rule

MySQL Database

MySQL features
MySQL Create Database
MySQL Select Database
MySQL Show Databases
MySQL Drop Database

MySQL Tables

MySQL CREATE Table
MySQL ALTER table
MySQL Select Show Tables
MySQL Rename Table
MySQL Drop Tables

MySQL Queries

MySQL Constraints
MySQL INSERT Record
MySQL UPDATE Record
MySQL DELETE Record
MySQL SELECT Record

MySQL Clauses

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

MySQL Conditions

MySQL AND
MySQL OR
MySQL LIKE
MySQL IN
MySQL ANY
MySQL EXISTS
MySQL NOT
MySQL NOT Equal
MySQL IS NULL
MySQL IS NOT NULL
MySQL BETWEEN

MySQL Keys

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

MySQL NOT EQUAL Operator

MySQL Not Equal is an inequality operator that used for returning a set of rows after comparing two expressions that are not equal. The MySQL contains two types of Not Equal operator, which are (< >) and (! =).

Difference Between (< >) and (! =) Operator

The Not Equal operators in MySQL works the same to perform an inequality test between two expressions. They always give the same result. However, they contain one difference that “< >” follows the ISO standard whereas “!=” does not follow ISO standard.

Let us understand it by this table example :

If you want to get the name of people who do not belong to Haryana, then you need to execute the following command:

Or you can do like this :

Let's move on to use of IS NULL in MySQL

MySQL NOT

MySQL IS NULL

Share this page on :