What MySQL EXPORT_SET() function returns if any of the argument is NULL?

MySQL EXPORT_SET() function would return NULL if any of the argument provided in it is NULL. Following examples would demonstrate it −

Example

mysql> Select EXPORT_SET(NULL, 'Y','N',',', 4);

+----------------------------------+
| EXPORT_SET(NULL, 'Y','N',',', 4) |
+----------------------------------+
| NULL                             |
+----------------------------------+

1 row in set (0.00 sec)

mysql> Select EXPORT_SET(5, NULL,'N',',', 4);

+--------------------------------+
| EXPORT_SET(5, NULL,'N',',', 4) |
+--------------------------------+
| NULL                           |
+--------------------------------+

1 row in set (0.00 sec)

mysql> Select EXPORT_SET(5, 'Y','N',',', NULL);

+----------------------------------+
| EXPORT_SET(5, 'Y','N',',', NULL) |
+----------------------------------+
| NULL                             |
+----------------------------------+

1 row in set (0.00 sec)

mysql> Select EXPORT_SET(5, 'Y','N',NULL, 4);

+--------------------------------+
| EXPORT_SET(5, 'Y','N',NULL, 4) |
+--------------------------------+
| NULL                           |
+--------------------------------+

1 row in set (0.00 sec)

Fendadis John

Published on 20-Feb-2018 06:39:29

• Related Questions & Answers
• What MySQL returns if the argument of QUOTE() function is NULL?
• What MySQL returns if the first argument of INTERVAL() function is NULL?
• What MySQL returns if the list of strings, provided as argument in FIELD() function, are NULL?
• What MySQL COALESCE() function returns if it has a blank, but not NULL, as the first argument?
• What MySQL returns if the search string, provided in FIELD() function, is NULL?
• What MySQL returns if we use UNIX_TIMESTAMP() function with no argument?
• What happens if a NULL argument is provided in MySQL CONV() function?
• What MySQL MAKE_SET() function returns if the value of the bit is 1 and the first string is NULL?
• What MySQL TRIM() function returns if 1st argument(i.e. BOTH, LEADING, TRAILING) is not specified?
• What MySQL returns if we use NULL, as both the arguments, as one of the argument and as a separator, in CONCAT_WS() function?
• What MySQL MAKE_SET() function returns if there are all NULL at the place of strings?
• 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 the index number, provided as an argument, is higher than the number of strings?
• What MySQL ASCII() function returns if I will provide NULL to it?
• What MySQL ELT() function returns if we the index number, provided as an argument, is less than 1?