What happens when MySQL's MAKE_SET() function returns NULL?

MySQL MAKE_SET() function returns NULL if the value of the bit is NULL, otherwise the function ignores NULL in any other position. The following example will demonstrate this functionality −

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)

The above is the detailed content of What happens when MySQL's MAKE_SET() function returns NULL?. For more information, please follow other related articles on the PHP Chinese website!