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


MySQL TUTORIALS » String Functions » EXPORT_SET »

 

EXPORT_SET(bits,on,off[,separator[,number_of_bits]])


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                     |
+-----------------------------+
row in set (0.00 sec)

mysql>



Leave a Comment / Note


 
Verification is used to prevent unwanted posts (spam). .

Follow Navioo On Twitter

MySQL TUTORIALS

 Navioo String Functions
» EXPORT_SET