All About MySQL.

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 …

MySQL LAST_INSERT_ID() – A Complete Guide Read More »

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, …

MySQL ON DELETE CASCADE – Complete Guide Read More »

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 …

MySQL BOOL, BOOLEAN – A Complete Guide Read More »

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 …

MySQL UUID_TO_BIN and BIN_TO_UUID Functions Read More »

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 …

MySQL UUID_SHORT() Function – A Complete Guide Read More »

In this tutorial, we will study the MySQL IS_UUID() function. In MySQL, UUID is a Universal Unique Identifier which is generated by the RFC 4122 standard, “A Universally Unique IDentifier (UUID) URN Namespace”. The function IS_UUID() is used to check whether the parameter is valid UUID or not. The function will return 1 if the …

MySQL IS_UUID Function – A Complete Guide Read More »

In this tutorial, we will study the MySQL BINARY function and go through some examples to understand its primary use. MySQL BINARY function is used to convert the expression to the binary string. A binary string is a string that has binary collation and binary character-set. Note that this function won’t convert the value or …

MySQL BINARY function – A Complete Guide Read More »

In this tutorial, we will study the MySQL CASE function. The exciting thing about it is that MySQL also offers the CASE statement with syntax almost identical to the CASE function, but these are used for different use cases. So, we will see both; function and statement, with simple and easy-to-understand examples. Let’s start first …

MySQL CASE Function and CASE Statement Read More »