When MySQL MAKE_SET() function returns NULL?

MySQL MAKE_SET() function returns NULL if the value of the bit is NULL otherwise NULL at any other place is ignored by this function. Following example will demonstrate it −

Example

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

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

Sharon Christine

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

• Related Questions & Answers
• When MySQL IN() function returns NULL?
• When MySQL FIND_IN_SET() function returns NULL as output?
• When MySQL LOCATE() function returns NULL as the output?
• What MySQL MAKE_SET() function returns if there are all NULL at the place of strings?
• When a MySQL arithmetic expression returns NULL?
• What is MySQL MAKE_SET() function?
• What MySQL MAKE_SET() function returns if the value of the bit is 1 and the first string is NULL?
• What MySQL returns if the argument of QUOTE() function is NULL?
• What MySQL EXPORT_SET() function returns if any of the argument is NULL?
• What MySQL ASCII() function returns if I will provide NULL to it?
• What MySQL returns if the first argument of INTERVAL() function is NULL?
• What MySQL returns when we use DISTINCT clause with the column having multiple NULL values?
• What MySQL returns if the search string, provided in FIELD() function, is NULL?
• What MySQL COALESCE() function returns if all the arguments provided to it are NULL?
• When MySQL SUBSTRING_INDEX() function returns the same string, provided in the argument, as output?