
- Learn MySQL
- MySQL - Home
- MySQL - Introduction
- MySQL - Installation
- MySQL - Administration
- MySQL - PHP Syntax
- MySQL - Connection
- MySQL - Create Database
- MySQL - Drop Database
- MySQL - Select Database
- MySQL - Data Types
- MySQL - Create Tables
- MySQL - Drop Tables
- MySQL - Insert Query
- MySQL - Select Query
- MySQL - Where Clause
- MySQL - Update Query
- MySQL - Delete Query
- MySQL - Like Clause
- MySQL - Sorting Results
- MySQL - Using Join
- MySQL - NULL Values
- MySQL - Regexps
- MySQL - Transactions
- MySQL - Alter Command
- MySQL - Indexes
- MySQL - Temporary Tables
- MySQL - Clone Tables
- MySQL - Database Info
- MySQL - Using Sequences
- MySQL - Handling Duplicates
- MySQL - SQL Injection
- MySQL - Database Export
- MySQL - Database Import
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 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 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 use both G and semicolon (;) termination symbol with a single MySQL statement?
- What MySQL returns if I provide a non-hexadecimal number as an argument to UNHEX() function?
- What happens if I will delete a row from MySQL parent table?
- What happens if the output of MySQL TIMEDIFF() function surpass the range value of TIME field?
- What happens if the argument ‘count’ in MySQL SUBSTRING_INDEX() function has the value greater than the total number of occurrences of delimiter?
- What happens if a NULL argument is provided in MySQL CONV() function?
- What would be the output of MySQL ELT() function if the index number, provided as an argument, is not an integer?
- How can I use a SELECT statement as an argument of MySQL IF() function?
- What happens if we provide NULL as an argument to MySQL CHAR() function?
- What MySQL ASCII() function returns if I will provide NULL to it?
- What will MySQL CHAR_LENGTH() function return if I provide NULL to it?

Advertisements