1 不同进制的数字转换
下例将16进制的a转化为2进制的1010
mysql> SELECT CONV('a',16,2);
+----------------+
| CONV('a',16,2) |
+----------------+
| 1010 |
+----------------+
1 row in set (0.01 sec)
2 重复执行指定操作的函数
SELECT BENCHMARK(50000,PASSWORD('abcdef'));
+-------------------------------------+
| BENCHMARK(50000,PASSWORD('abcdef')) |
+-------------------------------------+
| 0 |
+-------------------------------------+
1 row in set, 1 warning (0.01 sec)
3 改变字符集的函数
SELECT CHARSET('aa'),CHARSET(CONVERT('aa' USING latin1));
+---------------+-------------------------------------+
| CHARSET('aa') | CHARSET(CONVERT('aa' USING latin1)) |
+---------------+-------------------------------------+
| utf8 | latin1 |
+---------------+-------------------------------------+
1 row in set (0.00 sec)