top | item 19085846

(no title)

sarabob | 7 years ago

Yay, you're one of today's lucky 10,000 [0]!

There are different types of UUIDs [1]. MySQL generates version 1 UUIDs - you can tell by the first digit of the third block. It looks like something else is also generating UUIDs, using the v4 format - so you have two different types of UUID in your database:

4331cb9e-1d91-11e9-be2c-45923c63e8a2 # v1

c7e2f124-f6ba-4434-843f-89958a7436ec # v4

v1 UUIDs are typically based on the MAC address of your computer and the current time. Online tools exist [2] that decode the uuid and tell you it was created at 2019-01-21 10:28:55 (UTC)

v4 UUIDs are random.

[0] https://xkcd.com/1053/

[1] https://en.wikipedia.org/wiki/Universally_unique_identifier

[2] https://realityripple.com/Tools/UnUUID/

discuss

order

No comments yet.