In this tutorial, we will learn about the MySQL UPDATE Statement. It may happen that you entered a wrong value in a column for a record in the table. Another situation may arise that a certain value may need to be changed over time. MySQL provides us with the UPDATE statement for such operations. The …
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 »