+ -
当前位置:首页 → 问答吧 → mysql5.1 hash function(Non-cryptographic)

mysql5.1 hash function(Non-cryptographic)

时间:2011-08-12

来源:互联网

Some times, we want to use a hash funtion which is non-cryptographic,only create a number value,but mysql can't provide it, so I merge the "One At A Time hashing function" into mysql5.1,it  was originally created by Bob Jenkins.you can get my mysql hash function code from follow url:
http://forge.mysql.com/tools/tool.php?id=334

详细的介绍见我的博客:
http://philipzhong.blogspot.com/ ... h-functionsudf.html


select hash32("A2ff7402d89c1086119bd7f17176ba66EEEEEEEEEEEEEEEEYYYYYYYY8888888888888888888888888888888888888888888888888888888") as hash32
+------------+
| hash32     |
+------------+
| 1143512335 |
+------------+

select hash32("1111111111111111111111111111111111111111") as hash32
+------------+
| hash32     |
+------------+
| 1867344944 |
+------------+

select hash32("aaabbbbbcccc1122228888888888888888888888") as hash32
+------------+
| hash32     |
+------------+
| 2697799865 |
+------------+

作者: philip_zhong   发布时间: 2011-08-12

帮up

作者: hmeng16   发布时间: 2011-08-13