mysql 有无函数能够使得左侧补零？

Question

具体应用如下语句mysql> select CONV(3611120339,10,16);
+------------------------+
| CONV(3611120339,10,16) |
+------------------------+
| D73D52D3               |
+------------------------+
1 row in set (0.00 sec)
希望将输出的D73D52D3左侧自动补零凑足10位16进制数，缺几个就能自动补几个0，这样的要求如何能做到？

Answer 1

mysql> select right(concat('00000',CONV(3611120339,10,16)),10); 
+--------------------------------------------------+
| right(concat('00000',CONV(3611120339,10,16)),10) |
+--------------------------------------------------+
| 00D73D52D3                                       | 
+--------------------------------------------------+
1 row in set (0.00 sec)