In this tutorial, we will study the MySQL GROUP BY clause. The MySQL GROUP BY clause collects data from multiple rows and groups the rows into subgroups based on their value. GROUP BY is usually used with the SELECT statement. As you proceed with this tutorial and in the world of databases, you will notice that …
MySQL GROUP BY – Easy Guide To Grouping Data In MySQL Read More »
In this tutorial, we will learn the MySQL LIMIT clause. Suppose you want to display the list of students in a table, in descending order of marks in Maths. That can be done using the WHERE clause. However, if you only want to display the top three students who scored the highest in Maths, MySQL …
In this tutorial, we will explore the MySQL INSERT INTO statement. Suppose you have a table ready with columns and now you wish to put in values in it. To put values in a table, MySQL provides you with the INSERT statement. It is important to note that the CREATE TABLE statement enables you to …
MySQL INSERT INTO Statement – How to insert values into a table in MySQL? Read More »
In this tutorial, we will learn about the MySQL CREATE TABLE Statement. A table is a structure that is used to organize and store data in rows and columns. Each table in a database must have a unique name to identify it with. One of the harder parts of large scale projects is determining what …
MySQL CREATE TABLE – How to create a table in MySQL? Read More »
In this tutorial, we will learn about the MySQL LIKE Operator. Suppose you are going through a record of names and you want to find out names beginning with ‘P’. Furthermore, what if you want to find names that end with ‘r’. For these purposes, MySQL provides us with the LIKE Operator. The MySQL LIKE …
MySQL LIKE Operator – Partial Matching Conditional Queries Read More »
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 »