EXPORT_SET(bits,on,off[,separator[,number_of_bits]]) : EXPORT_SET « String Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. String Functions
  3. EXPORT_SET

Set in the value bits by on string and off string.

Separated is set by the separator string.

The default is the comma character ','.

The number of bits is set by number_of_bits.

number_of_bits defaults to 64.

mysql>
mysql> SELECT EXPORT_SET(5,'Y','N',',',4);
+-----------------------------+
| EXPORT_SET(5,'Y','N',',',4) |
+-----------------------------+
| Y,N,Y,N                     |
+-----------------------------+
1 row in set (0.00 sec)

mysql>








23.11.EXPORT_SET
23.11.1.EXPORT_SET(bits,on,off[,separator[,number_of_bits]])
23.11.2.SELECT EXPORT_SET(6,'1','0',',',10);