In this tutorial, we will learn how to add a dollar ($) sign for currency data. We will see different solutions that you can use in your application to add the $ dollar sign. So without further ado, let’s dive into it! Introduction There are multiple circumstances where you have to deal with the users …
While learning MySQL, you might get stuck multiple times thinking about how this is different from that, right? The same goes for the window functions and the aggregate functions. If you have recently started learning MySQL, then you might be thinking about how window functions differ from aggregate functions. In this tutorial, we will see …
Window Functions VS Aggregate Functions in MySQL Read More »
The LEFT JOIN is often used in any project to combine the data of two tables. You might have joined only two tables using the LEFT JOIN until now. But today, we will learn to join multiple tables using the LEFT JOIN. It is very simple and easy to understand if you get the basic …
When someone starts learning MySQL or any other DBMS, one of the earliest places where the students get stuck is where to use group by and order by clause. Though order by clause is simple and straightforward, the group by is a little bit confusing to new learners. In this tutorial, we will see detailed …
Difference Between GROUP BY and ORDER BY – Simple Explanation Read More »
MySQL provides us with a wide range of functions to deal with dates, maths calculations, string manipulation etc. However, MySQL lacks some functions that are available in other DBMSs. The date_trunc function is one of the missing features of MySQL which is available in PostgreSQL DBMS. In this tutorial, we will see what are some …
In this tutorial, we will learn how we can handle the duplicate insertion of the record in a MySQL table. It is a very easy process and needs a single statement which is the “INSERT ON DUPLICATE KEY UPDATE”. Make sure you read the tutorial carefully and try it to understand it properly. So, let’s …
In this tutorial, we will learn how we can return specific values or data from the JSON document using the MySQL function JSON_EXTRACT(). It is super simple to understand and implement. We will see multiple examples and ways to extract the values from the JSON data in this tutorial. So without further ado, let’s get …
MySQL JSON_EXTRACT – How to Extract Data From JSON Document? Read More »
In this tutorial, we will learn everything about the SMALLINT datatype in MySQL. It is similar to the integer datatype but has a smaller range. So, let’s get started! Also read: MySQL INT Datatype Brushing Up the Basics MySQL provides us with multiple versions of integer datatype such as TINYINT, SMALLINT, MEDIUMINT, INT, and BIGINT. …
Everything You Need to Know About MySQL SMALLINT Read More »
In this tutorial, we will learn about the UPDATE JOIN statement. The UPDATE JOIN statement is basically used to update the table data based on the joins. We will see how to perform the update join operation using the left join as well as the inner join. So, let’s get started! Also read: MySQL FULL …
In this tutorial, we will learn about the “not equal” operator in MySQL which is used to find the records which are not equal to a given expression. So, let’s get started! Introduction to MySQL Not Equal To Operator The “Not equal to” operator is exactly opposite to the equal to operator. When you want …