Actually, 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 up to 64 Bit by bit and generate the result. It can be understood from the following example -
mysql> SELECT EXPORT_SET(5, 'Y','N',' ')\G *************************** 1. row *************************** EXPORT_SET(5, 'Y','N',' '): Y 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 N 1 row in set (0.00 sec)
In this example, MySQL checks up to 64 bits and we use spaces as separators.
The above is the detailed content of What happens to the output of the MySQL EXPORT_SET() function if I skip the value of the fifth parameter (i.e. multiple bits)?. For more information, please follow other related articles on the PHP Chinese website!