EXPORT_SET()

Overview

Returns a string representation of a bits argument, using the given values for on and off.

EXAMPLES

SELECT EXPORT_SET(2,'Y','N',',',2);
+-----------------------------+
| EXPORT_SET(2,'Y','N',',',2) |
+-----------------------------+
| N,Y                         |
+-----------------------------+
SELECT EXPORT_SET(2,'Y','N',',',10);
+------------------------------+
| EXPORT_SET(2,'Y','N',',',10) |
+------------------------------+
| N,Y,N,N,N,N,N,N,N,N          |
+------------------------------+
SELECT EXPORT_SET(3,'Y','N',',',5);
+-----------------------------+
| EXPORT_SET(3,'Y','N',',',5) |
+-----------------------------+
| Y,Y,N,N,N                   |
+-----------------------------+
SELECT EXPORT_SET(3,'1','0',',',5);
+-----------------------------+
| EXPORT_SET(3,'1','0',',',5) |
+-----------------------------+
| 1,1,0,0,0                   |
+-----------------------------+

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0.

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

10.3 Community

  • Present starting in MariaDB Community Server 10.3.0.

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1.

10.2 Community

  • Present starting in MariaDB Community Server 10.2.0.

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES