What MySQL MAKE_SET() function returns if there are all NULL at the place of strings?

MySQL MAKE_SET() function will return nothing if there are all NULL at the place of strings. Following example will demonstrate it −

Example

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

Rama Giri

Published on 21-Feb-2018 11:23:11

• Related Questions & Answers
• When MySQL MAKE_SET() function returns NULL?
• What MySQL returns if the list of strings, provided as argument in FIELD() function, are NULL?
• What MySQL COALESCE() function returns if all the arguments provided to it are NULL?
• What MySQL MAKE_SET() function returns if the value of the bit is 1 and the first string is NULL?
• What MySQL COUNT() function returns if there are some NULL values stored in a column also?
• 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 returns if the first argument of INTERVAL() function is NULL?
• What is MySQL MAKE_SET() function?
• What MySQL returns if the search string, provided in FIELD() function, is NULL?
• What MySQL ASCII() function returns if I will provide NULL to it?
• What MYSQL INTERVAL() function returns if there is no bigger number in the list of arguments than the number at first argument?
• When MySQL IN() function returns NULL?
• When MySQL LOCATE() function returns NULL as the output?
• When MySQL FIND_IN_SET() function returns NULL as output?