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, …
In this tutorial, we will study the MySQL IS_IPV4() and IS_IPV6() functions. If your friend wishes to send you a parcel, they would want to know your address so that it reaches you safely. In a similar way, computers or hardware have addresses called IP addresses. IP stands for Internet Protocol. An IP address is …
In this tutorial, we will study the MySQL ISNULL() and IFNULL() functions. Checking for NULL values and handling them while displaying results is a key database operation. While you can always add a WHERE clause to check for NULL in a column of a table, MySQL provides you with additional ways to tackle this problem. …
In this tutorial, we will study the MySQL IF() condition. Decision making is a process that you come across in real life. Decision making has many applications and use cases in the computing world. Suppose you have a table of student marks and you need to print a pass/fail grade for them. If a student …
In this tutorial, we will study the MySQL UUID() function. You must have heard of unique identification numbers or identifiers. Applications extend from your exam seat numbers to your Aadhar Card numbers/SSN Numbers and so on. Suppose you have a MySQL table of people and you have been tasked with assigning each one of them …
MySQL UUID() – Generate Unique Identifiers in MySQL Read More »
In this tutorial, we will study the MySQL UTC_TIME(), UTC_DATE() and UTC_TIMESTAMP() functions. Coordinated Universal Time or UTC is the primary time standard by which the world regulates clocks and time. It is within about 1 second of mean solar time at 0° longitude, and is not adjusted for daylight saving time. It is effectively …
MySQL UTC_TIME(), UTC_DATE() and UTC_TIMESTAMP() functions Read More »