
- 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 the value of the fifth argument i.e. a number of bits?
Actually, 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. 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)
Here in this example, MySQL checked up to 64 bits and we use the space as separator.
- Related Articles
- 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?
- What happens if I pass only one argument to the MySQL CONCAT() function?
- 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 I will use integer values as arguments of MySQL LOCATE() function?
- While linking the strings, if I will add a NULL value then what would be the output of a CONCAT_WS() function?
- While linking two strings, if I will add a NULL value then what would be the output of a CONCAT() 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?
- 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 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 MySQL returns if the argument of QUOTE() function is NULL?
- What happens if a NULL argument is provided in MySQL CONV() function?

Advertisements