UUID_TO_INT

uuid_to_int

description

LARGEINT uuid_to_int(VARCHAR uuid)

对于输入的 uuid 字符串，返回一个 int128 表示。

example

mysql> select uuid_to_int("6ce4766f-6783-4b30-b357-bba1c7600348");
+-----------------------------------------------------+
| uuid_to_int('6ce4766f-6783-4b30-b357-bba1c7600348') |
+-----------------------------------------------------+
| 95721955514869408091759290071393952876              |
+-----------------------------------------------------+

keywords

UUID_TO_INT