SM3
描述
计算 SM3 256-bit
语法
SM3( <input> )
参数
参数 | 说明 |
---|---|
<input> | 需要被计算 sm3 的值, 接受字符串和二进制类型 |
返回值
返回输入字符串的 sm3 值
示例
-- vb (VarBinary) 和 vc (VarChar) 插入时使用了相同的字符串.
SELECT * FROM mysql_catalog.binary_test.binary_test;
+------+------------+------+
| id | vb | vc |
+------+------------+------+
| 1 | 0x616263 | abc |
| 2 | 0x78797A | xyz |
| 3 | NULL | NULL |
+------+------------+------+
SELECT SM3(vb), SM3(vc) FROM mysql_catalog.binary_test.binary_test;
+------------------------------------------------------------------+------------------------------------------------------------------+
| SM3(vb) | SM3(vc) |
+------------------------------------------------------------------+------------------------------------------------------------------+
| 66c7f0f462eeedd9d1f2d46bdc10e4e24167c4875cf2f7a2297da02b8f4ba8e0 | 66c7f0f462eeedd9d1f2d46bdc10e4e24167c4875cf2f7a2297da02b8f4ba8e0 |
| 869fff440724014a7e086c8b3680f4cfc6a3390670f6e7755a4f0c43c1c31db6 | 869fff440724014a7e086c8b3680f4cfc6a3390670f6e7755a4f0c43c1c31db6 |
| NULL | NULL |
+------------------------------------------------------------------+------------------------------------------------------------------+