What MySQL MAKE_SET() function returns if the value of the bit is 1 and the first string is NULL?

MySQL MAKE_SET() function returns nothing if the value of the bit is 1 and the first string is NULL. Following example will exhibit this concept −

Example

mysql> Select MAKE_SET(1, NULL,'A','B');
+---------------------------+
| MAKE_SET(1, NULL,'A','B') |
+---------------------------+
|                           |
+---------------------------+
1 row in set (0.00 sec)

Monica Mona

Published on 21-Feb-2018 11:24:16

• Related Questions & Answers
• What MySQL returns if the first argument of INTERVAL() function is NULL?
• When MySQL MAKE_SET() function returns NULL?
• What MySQL returns if the argument of QUOTE() function is NULL?
• What MySQL MAKE_SET() function returns if there are all NULL at the place of strings?
• What MySQL returns if the search string, provided in FIELD() function, is NULL?
• What MySQL EXPORT_SET() function returns if any of the argument is NULL?
• What is MySQL MAKE_SET() function?
• What MySQL COALESCE() function returns if it has a blank, but not NULL, as the first argument?
• MySQL query that returns a specific string if column is null?
• What is the difference between MySQL ISNULL() function and IS NULL operator?
• What MySQL returns if the search string is not in the list of strings provided as argument in FIELD() function?
• What MySQL ELT() function returns if we the index number, provided as an argument, is less than 1?
• What MySQL COALESCE() function returns if all the arguments provided to it are NULL?
• What MySQL returns if we pass column name, containing a NULL value, as one of the arguments of CONCAT() function?
• What MYSQL INTERVAL() function returns if there is no bigger number in the list of arguments than the number at first argument?