11.12.2 CONV(value,from,to)函数
CONV(value,from,to)函数将value的值进行不同进制之间的转换,value是一个整数,如果任意一个参数为NULL,则结果返回NULL。使用示例如下:
mysql> SELECT CONV(16, 10, 2), CONV(8888,10,16), CONV(NULL, 10, 2);
+-----------------+------------------+-------------------+
| CONV(16, 10, 2) | CONV(8888,10,16) | CONV(NULL, 10, 2) |
+-----------------+------------------+-------------------+
| 10000 | 22B8 | NULL |
+-----------------+------------------+-------------------+
1 row in set (0.00 sec)