MySQL provides us with a wide range of aggregate functions that make our life easier. The MySQL GROUP_CONCAT() is one of those aggregate functions pretty similar to MySQL CONCAT() aggregate function. Jowever, it is built for a slightly different purpose. In this tutorial, we will study the MySQL GROUP_CONCAT() function and learn how to use …
In this tutorial, we will study an easy yet powerful statement- INSERT INTO SELECT. In official MySQL documentation, it is described as INSERT … SELECT; however, people prefer calling it INSERT INTO SELECT. We will also be looking at its syntax, examples, and points that you should avoid getting successful results from the given statement. …
In this article, let’s discuss the differences between MariaDB vs MySQL. MySQL, without a doubt, is one of the most famous and in-demand database management systems. However, different forks of original MySQL have been created due to uncertainties and distrust in the MySQL community after acquiring MySQL by SUN and later SUN by Oracle. MariaDB …
ACID properties are one of the most important rules that everyone should know before diving into any complex database project or becoming a good programmer. In this tutorial, we will learn the ACID properties in DBMS with some excellent and easy real-time examples. But before that, understand the concept-“transaction” in DBMS. A database transaction is …
ACID properties in DBMS – Atomicity, Consistency, Isolation, and Durability Read More »
In this tutorial, we will learn how to connect the MySQL database with the Python program and write different queries. We will start with a basic introduction, go through MySQL set up in Python, and then execute further queries for creating, reading, deleting, and updating the data. Let’s start with an introduction. Using MySQL with …
Python MySQL – Connect a MySQL Database with Python Read More »
The MySQL LAST_INSERT_ID() function of MySQL does exactly as it reads. It will return the latest ID of the AUTO_INCREMENT column. This can be a useful little function to find out the latest ID of the AUTO_INCREMENT column. The LAST_INSERT_ID() function can be used without an expression and also with an expression. This function when …
In this tutorial, we will learn what is ON DELETE CASCADE, how to use it, and some more concepts related to it. Did you ever fall into a situation where you wanted to delete all the matching records in the child table when one of the records in the parent table gets deleted? If yes, …
In this tutorial, we will learn the MySQL data type BOOL and BOOLEAN. We will also be learning how to implement boolean in the queries and some exceptions you must know. We will also go through some simple and practical examples to understand the BOOL and BOOLEAN data types. What is BOOLEAN data type in …
In this tutorial, we will study two essential MySQL functions, UUID_TO_BIN() and BIN_TO_UUID(). These functions are related to the UUID() function and are only available in MySQL version above 8.0, so upgrade your MySQL if you do not have the latest version. Also read: MySQL UUID_SHORT() Function – A Complete Guide UUID_TO_BIN() and BIN_TO_UUID() Functions …
In this article, we will study the MySQL UUID_SHORT() function with its syntax, examples, and advantages over the UUID() function. We will also be learning how the short UUID is created, the logic behind it, and the alternative methods to the UUID_SHORT(). What is UUID_SHORT() Function? As the name suggests, UUID_SHORT() is a MySQL function …