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 »
In this tutorial, we will study the MySQL STR_TO_DATE() function. Suppose you have a table of details of a few people. One of the columns in the table is DOB which specifies the date of birth of each individual as a string. An example of the date string format is – ‘August 29, 2020’. You …
MySQL STR_TO_DATE() – Convert Date String to MySQL Date Read More »
In this tutorial, we will learn about the MySQL GET_FORMAT() function. Before you proceed with this article, I would highly encourage you to read the DATE_FORMAT() article as this tutorial builds on concepts learnt in that article. Suppose you have a list of joining dates of employees in your company. These dates have been stored …
MySQL GET_FORMAT() – Convert MySQL Dates to Standardized Formats Read More »
In this tutorial, we will study the MySQL COALESCE() function. Suppose you have a table of contact details of a thousand people. The contact details can be a mobile number, a home number or a work phone. There is a column for each of these contact details. Note that not all contact detail columns are …
In this tutorial, we will learn about the MySQL DATE_FORMAT() function. The date value in MySQL is in the format “YYYY-MM-DD”. However, such a date value may be difficult to read for some people – who prefer it in some other format like DD/MM/YYYY or MM/DD/YYYY. Some people may prefer to see the day name …