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 …
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 …
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 …
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 …
As the name suggests, MySQL CONVERT() function converts the value from one data type to another. It’s that simple! Let’s suppose you have a float value in your program, which is generated somehow, and you want to store it in the database as an integer after rounding it. In such a case, you can use …
When working with a number different of data types the MySQL CAST() function comes in handy. It will help in casting the specified expressions to a specified data type. Typecasting refers to the process of manually changing the data type of an expression. The CONVERT() function is equivalent of the CAST() Function. To understand this …
The MySQL NULLIF Function is very useful when it comes to checking if two values are equal and getting a value in return. It is categorized as a Flow Control Function. A Flow Control Function means you can control the flow of the program based on the return value given by a function. The NULLIF() …
The MySQL NULLIF() Function With 5 Easy Examples Read More »
MySQL has plenty of date-time functions like MySQL SYSDATE(), NOW(), CURDATE(). All of them are different from each other in some manner; that’s why those all exist! In this tutorial, we will go through the MySQL SYSDATE() function with some nice and clear examples. The SYSDATE() function is used to get the date and time …
In this tutorial, we will study the MySQL MAKE_SET() function. The MAKE_SET() function is used to return a set value (a string containing substrings separated by “,”) consisting of the strings that have the corresponding bit in the first argument. Confusing right? Let’s make the concept clear by looking at a few examples but first, …