в 13:44, 26 мая 2010

2010-05-26T13:44:56Z

Admin: 1 версия

2010-05-26T09:49:27Z

1 версия

Новая страница

== 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.



<source lang="sql">
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></source>

== SELECT EXPORT_SET(6,"1","0",",",10);==



<source lang="sql">
mysql>
mysql>
mysql> SELECT EXPORT_SET(6,"1","0",",",10);
+------------------------------+
| EXPORT_SET(6,"1","0",",",10) |
+------------------------------+
| 0,1,1,0,0,0,0,0,0,0 |
+------------------------------+
1 row in set (0.00 sec)
mysql></source>

← Предыдущая	Версия 13:44, 26 мая 2010
(нет различий)

MySQL Tutorial/String Functions/EXPORT SET - История изменений

в 13:44, 26 мая 2010

Admin: 1 версия