What happens with the output of MySQL EXPORT_SET() function if I will skip both 4th and 5th argument i.e. separator and number of bits?
As we know that the default value of the fifth argument i.e. number of bits is 64, hence if we will not specify any value on fifth argument them MySQL will check the bits up to 64 bits and produce the result. Whereas, on skipping the fourth argument i.e. separator, MySQL will use a comma (,) as a separator while 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)
Related Articles
- What happens with the output of MySQL EXPORT_SET() function if I will skip the value of the fifth argument i.e. a number of bits?
- What MySQL TRIM() function returns if 1st argument(i.e. BOTH, LEADING, TRAILING) is not specified?
- What MySQL returns if we use NULL, as both the arguments, as one of the argument and as a separator, in CONCAT_WS() function?
- What happens if I pass only one argument to the MySQL CONCAT() function?
- What happens if I will use integer values as arguments of MySQL LOCATE() function?
- What happens if the output of MySQL TIMEDIFF() function surpass the range value of TIME field?
- What happens if I use both G and semicolon (;) termination symbol with a single MySQL statement?
- What happens if a NULL argument is provided in MySQL CONV() function?
- What happens if the argument ‘count’ in MySQL SUBSTRING_INDEX() function has the value greater than the total number of occurrences of delimiter?
- What would be the output of MySQL ELT() function if the index number, provided as an argument, is not an integer?
- What happens if we provide NULL as an argument to MySQL CHAR() function?
- What MySQL returns if the argument of QUOTE() function is NULL?
- What MySQL returns if I provide a non-hexadecimal number as an argument to UNHEX() function?
- What would be effect of negative value of second argument, which specifies the number of decimal places, on the output of MySQL ROUND() function?
- What would be effect of negative value of second argument, which specifies the number of decimal places, on the output of MySQL TRUNCATE() function?
Kickstart Your Career
Get certified by completing the course
Get Started