如果任何参数为 NULL，MySQL EXPORT_SET() 函数将返回什么?
mysqlmysqli database
如果 MySQL EXPORT_SET() 函数中提供的任何参数为 NULL，它将返回 NULL。以下示例将演示这一点 −
示例
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)
