What does the MySQL EXPORT_SET() function return if any argument is NULL?-Mysql Tutorial-php.cn

What does the MySQL EXPORT_SET() function return if any argument is NULL?

王林

Release： 2023-09-02 20:17:02

forward

1139 people have browsed it

如果任何参数为 NULL，MySQL EXPORT_SET() 函数返回什么？

If any parameter provided in the MySQL EXPORT_SET() function is NULL, the function will return NULL. The following example will demonstrate it -

Example

mysql> Select EXPORT_SET(NULL, &#39;Y&#39;,&#39;N&#39;,&#39;,&#39;, 4);

+----------------------------------+
| EXPORT_SET(NULL, &#39;Y&#39;,&#39;N&#39;,&#39;,&#39;, 4) |
+----------------------------------+
| NULL                             |
+----------------------------------+

1 row in set (0.00 sec)

mysql> Select EXPORT_SET(5, NULL,&#39;N&#39;,&#39;,&#39;, 4);

+--------------------------------+
| EXPORT_SET(5, NULL,&#39;N&#39;,&#39;,&#39;, 4) |
+--------------------------------+
| NULL                           |
+--------------------------------+

1 row in set (0.00 sec)

mysql> Select EXPORT_SET(5, &#39;Y&#39;,&#39;N&#39;,&#39;,&#39;, NULL);

+----------------------------------+
| EXPORT_SET(5, &#39;Y&#39;,&#39;N&#39;,&#39;,&#39;, NULL) |
+----------------------------------+
| NULL                             |
+----------------------------------+

1 row in set (0.00 sec)

mysql> Select EXPORT_SET(5, &#39;Y&#39;,&#39;N&#39;,NULL, 4);

+--------------------------------+
| EXPORT_SET(5, &#39;Y&#39;,&#39;N&#39;,NULL, 4) |
+--------------------------------+
| NULL                           |
+--------------------------------+

1 row in set (0.00 sec)

Copy after login

The above is the detailed content of What does the MySQL EXPORT_SET() function return if any argument is NULL?. For more information, please follow other related articles on the PHP Chinese website!