Author Archives: user

MySQL – MINUS Operator Table of content MySQL MINUS Operator The MySQL MINUS operator is one of the set operators which is used to fetch unique records from one table that do not exist in another table. In other words, the MINUS operator compares two tables and returns the unique rows from the first table […]

MySQL – IS NOT NULL Operator Table of content A NULL value in a MySQL table indicates a missing or unknown value. It appears to be blank and does not contain any data. This is different from zero values. It is very important to understand that a NULL value is different than a zero value […]

MySQL – IS NULL Operator Table of content NULL values in a MySQL table fields indicate that no (or unknown) values are present in them. These values are different from zeroes or invalid values. In MySQL, it is not possible to check NULL values with comparison operators such as =, <, or <>. Instead, we […]