MySQL Examples and Tutorials
In this tutorial, we will learn about the MySQL NOT BETWEEN operator. In the MySQL BETWEEN operator article, we saw how we can return records within a range. It also helped us avoid conditions with the AND operator and making our code more readable and effective. MySQL NOT BETWEEN is a combination of two operators …
In this tutorial, we’ll learn about MySQL BETWEEN operator. Suppose you are a school teacher and you want to find out the students who scored marks between 60 and 80 in Science. You could make use of the comparison operators along with the AND operator but a more effective way is using the MySQL BETWEEN …
In this tutorial, we will learn about the MySQL ORDER BY clause. Ordering and sorting as a feature in tables and databases are very important. This helps you analyze information and provide you with valuable insights into it. You could be the CEO of the company and sort the profit of every product you sell …
MySQL ORDER BY Clause – How to Sort Records In A Table? Read More »
In this tutorial, we will take a look at the MySQL IS NOT NULL condition. IS NOT NULL condition is the exact opposite of the IS NULL condition. IS NOT NULL filters through the table for a column and returns only those records who do not have a NULL value in that particular column. This …
MySQL IS NOT NULL Condition – Finding non-NULL values in a column Read More »
In this tutorial, we will take a look at the MySQL IS NULL condition. Suppose you are conducting a survey in your neighborhood and you hand out a small questionnaire to everyone in the area. After a day or two, you receive the questionnaires back and you notice that some people have not answered a …
MySQL IS NULL Condition – How-to Find And Replace NULL Vales in a Database? Read More »
In this quick tutorial, we’ll take a look at the MySQL NOT operator. Suppose you are a teacher and you want a list of students who were not present for all 100 days in a term. In other words, the condition of students present for 100 days should NOT be satisfied, and the resulting output …
In this tutorial, we’ll work on the MySQL OR operator. Suppose you are a teacher and you want to find out students who scored above 90 in their Maths or Science exams to be considered for the position of class monitor. So, in short, if a student scores above 90 in either Maths or Science, …
In this tutorial, we’ll be talking about the MySQL AND Operator. Suppose you are playing a video game and you pass a level only if you earn $50,000 and complete 2 missions. So, the logic is that you have two conditions you need to satisfy to pass the level. What if you encounter a similar …
MySQL AND Operator – Execute Multiple Conditions in MySQL Read More »
MySQL DESCRIBE query is used to describe a table. A short form of the DESCRIBE command is DESC. The DESCRIBE command is used to gain information about the table. It displays column names and the data type of every column along with the associated constraints. Suppose you are taking a walk in the city and …
MySQL DESCRIBE – Get Detailed Information on Database Tables Read More »
The MySQL NOT IN Operator does the exact opposite of the MySQL IN Operator. The NOT IN operator checks if a value is not present in a set of values and returns those values. Suppose you are a boarding school administrator and you want to know which of your students are not from Pune or …