使用mysql uuid_short() 函数生成17位UUID

2019独角兽企业重金招聘Python工程师标准>>>

Returns a "short" universal identifier as a 64-bit unsigned integer (rather than a string-form 128-bit identifier as returned by the UUID() function). The value of UUID_SHORT() is guaranteed to be unique if the following conditions hold: The server_id of the current host is unique among your set of master and slave servers server_id is between 0 and 255 You don't set back your system time for your server between mysqld restarts You do not invoke UUID_SHORT() on average more than 16 million times per second between mysqld restarts The UUID_SHORT() return value is constructed this way: (server_id & 255) << 56 + (server_startup_time_in_seconds << 24) + incremented_variable++;

mysql> SELECT UUID_SHORT(); -> 92395783831158784 Note that UUID_SHORT() does not work with statement-based replication.

 Buy cheap and genuine Windows 7 product key  |  Windows 7 Ultimate Key : Activation key, Free download  |  Windows 7 Product Key : Activation key, Free download  |  Windows 10 Product key : Activation key, Free download  |  Windows 8 Product key : Activation key, Free download  |  Office Professional Plus 2016 key : Activation key, Free download  |  Windows 7 Ultimate ISO download  |  Windows 7 Product Key Generator 32 bit and 64 bit Full  |  Windows 7 Ultimate Product Key 32-64bit [Free Keys] [2016]  |  Legit Windows 7 Product Key Online Store, PayPal Support  |  Windows 7 Ultimate with Service Pack 1 Product Key,Windows 7 Key Sale  |  Windows 10 keys, office 2016 keys, windows 7 keys: Valid Key Shop  | windows-10-education-key windows-10-enterprise-key office-2010-key windows-7-key-sale windows-10-home-key windows-10-activation-key windows-10-pro-key office-2016-key windows-10-key office-2013-key windows-10-iso windows-7-key windows-10-product-key

tips：

本文由wp2Blog导入，原文链接：http://devonios.com/msyql-use-uuid_short-function.html

转载于:https://my.oschina.net/yangyan/blog/859142