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