mysql uuid_short()
时间: 2023-12-07 07:03:11 浏览: 114
uuid64:短 UUID
MySQL的uuid_short()函数是在MySQL 5.1之后的版本提供的一个函数,用于生成一个64位的无符号整数。这个函数的返回值的构造方式是通过(server_id & 255) << 56 + (server_startup_time_in_seconds << 24) + incremented_variable来生成的。 与uuid()函数相比,uuid_short()函数生成的值相对较短,适用于需要较短唯一标识的情况。在MySQL中,可以通过自增序列、UUID()函数、和程序自定义的方式实现唯一值。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *3* [MySQL中的uuid()和uuid_short()函数](https://blog.csdn.net/ZZQHELLO2018/article/details/106532205)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
- *2* [MySQL-使用UUID_SHORT( ) 的问题](https://blog.csdn.net/TianXueWu/article/details/89085389)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]
阅读全文