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