What happens to the output of the MySQL EXPORT_SET() function if I skip the fourth and fifth parameters, delimiter and number of bits?

We know that the default value (i.e. number of bits) of the fifth parameter is 64, so if we don't specify any value on the fifth parameter, MySQL will check the bits up to 64 and Generate results. However, when the fourth parameter (i.e. delimiter) is skipped, MySQL will use a comma (,) as the delimiter when displaying the output.

Example

mysql> SELECT EXPORT_SET(8,'Y','N')\G
*************************** 1. row ***************************
EXPORT_SET(8,'Y','N'): N,N,N,Y,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N
1 row in set (0.00 sec)

The above is the detailed content of What happens to the output of the MySQL EXPORT_SET() function if I skip the fourth and fifth parameters, delimiter and number of bits?. For more information, please follow other related articles on the PHP Chinese website!