Home >Database >Mysql Tutorial >What happens to the output of the MySQL EXPORT_SET() function if I skip the value of the fifth parameter (i.e. multiple bits)?
What happens to the output of the MySQL EXPORT_SET() function if I skip the value of the fifth parameter (i.e. multiple bits)?
- 王林forward
- 2023-09-17 15:09:071215browse
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 -
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!
Statement：
This article is reproduced at:tutorialspoint.com. If there is any infringement, please contact admin@php.cn delete