MySQL EXPORT_SET() function
In this context, we will learn how we can use the MySQL EXPORT_SET() function with proper syntax and good examples.
Introduction of MySQL EXPORT_SET() function
This function returns a string and shows the bits in a number. 5 arguments are required to return a true result for this function. It converts Integer to Binary digits and returns "on" if the binary digit is 1 and "off" if the binary digit is 0.
Syntax of the MySQL EXPORT_SET() function
The syntax of the MySQL EXPORT_SET() function is given as follows:
EXPORT_SET(bits, on, off, separator, number of bits)
Parameters or arguments used in MySQL EXPORT_SET() function:
There are five parameters accepted by the EXPORT_SET() function in MySQL, which are mentioned above and described as follows:
1. bits –
This is the integer number for which the result will be formatted in this function.
2. on –
It will return when the binary digit is 1.
3. off –
It will return off when the binary digit is 0.
4. separator –
Between returned values this separator will be placed in it .
5. number of bits –
The number of bits in which the result will come
Returns:
This function will return a string that will show the bits in the number.
Application used for EXPORT_SET() function:
The EXPORT_SET() function can be used in the given below MySQL versions.:
- MySQL 5.7
- MySQL 5.6
- MySQL 5.5
- MySQL 5.1
- MySQL 5.0
- MySQL 4.1
- MySQL 4.0
- MySQL 3.23
Examples of MySQL EXPORT_SET() function:
Now we will look into some MySQL EXPORT_SET() function examples and will explore how we can use the EXPORT_SET function in MySQL.
Example-1 :
Here, we will see the Working of EXPORT_SET() function.
SELECT EXPORT_SET(10, 'On', 'Off', ':', 5) AS ExportSET;
Output:
ExportSET
Off: On : Off : On : Off
1 row in set (0.00 sec)
Example 2 :
Here, we will see the Working of EXPORT_SET() function by changing 2nd and 3rd arguments.
Here we will Use "Y" and "N" as the second and third arguments, respectively–
SELECT EXPORT_SET(11, 'Y', 'N', ', ', 4)
AS Export;
Output :
Export
Y, Y, N, Y
1 row in set (0.00 sec)
Here we will Use "1" and "0" as the second and third arguments, respectively –
SELECT EXPORT_SET(11, 1, 0, ', ', 4)
AS Export;
Output :
Export
1, 1, 0, 1
1 row in set (0.00 sec)
Example-3 :
Now, we will see the Working of the EXPORT_SET() function by changing the 4th argument.
In this example, we will use "-" as the fourth argument –
SELECT EXPORT_SET(10, 1, 0, '-', 4) AS ExportSET;
Output:
ExportSET
0-1-0-1
1 row in set (0.00 sec)
Here we will use "::" as the fourth argument –
SELECT EXPORT_SET(10, 1, 0, '::', 4)
AS Export;
Output:
Export
0::1::0::1
1 row in set (0.00 sec)
Example 4 :
Now, we will see the Working of the EXPORT_SET() function by changing the 5th argument.
Here we will Use 10 as the fifth argument –
SELECT EXPORT_SET(9, 'Y', 'N',' ', 10)
AS Export;
Output:
Export
Y N N Y N N N N N N
1 row in set (0.00 sec)
Here we will Use 20 as the fifth argument –
SELECT EXPORT_SET(9, 1, 0, ' ', 20)
AS Export;
Output:
Export
1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1 row in set (0.00 sec)
Application of MySQL EXPORT_SET() function:
This function helps to return a string which will show the bits in the number.
Summary:
In the above context, we have learned how to use the EXPORT_SET() function in MySQL, which helps return a string that will show the bits in the number.