MySQL Examples and Tutorials
An SQL JOIN and UNION both are used to combine the data from two or more tables having some relation. However, there is a difference between the JOIN and the UNION clause. In this tutorial, we will understand what are the similarities between them, the differences and when to use which clause. So, let’s get …
In a world where data is king, we need to choose applications and software for manipulating and maintaining our data. One such way is to use RDBMS or relational database management systems. In simple words, RDBMS is the collection of tables called a database. The database stores data in tabular format with additional information and …
PostgreSQL vs MySQL – Which Database Should You Choose? Read More »
SQL JOINs are often a good solution over the subqueries, but not every time. There might be chances join statement will not work faster where the subquery will and vice-versa. New learners get easily confused between the JOIN statement and the subqueries and which one to use. In this tutorial, we will see the differences …
MySQL is a popular relational database management system. It is open-source and is supported by operating systems such as macOS, Windows, Linux, etc. MySQL language makes it easy for users to create, maintain and manipulate databases. In this tutorial, we’ll learn how to install MySQL on a macOS machine. This is an easy-to-follow and step-by-step …
There are mainly two approaches to joining the tables, either using the names of multiple tables with the WHERE clause in the SELECT statement or using a JOIN statement. Which approach do you use often? In this tutorial, we will see both approaches with some examples and see why joins are preferred over the list …
Difference between JOIN and Multiple Tables in FROM Read More »
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 …