MySQL MAKE_SET() Function

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

MySQL MAKE_SET() Function Read More »

MySQL IF() Condition

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 …

MySQL IF() Condition Read More »

MySQL COALESCE() Function

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 …

MySQL COALESCE() Function Read More »

MySQL DATE_FORMAT()

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 …

MySQL DATE_FORMAT() Read More »