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.