7 ms·
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 t
by sarabob 8y 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/ https://xkcd.com/1053/
[1] https://en.wikipedia.org/wiki/Universally_unique_identifier https://en.wikipedia.org/wiki/Universally_unique_identifier
[2] https://realityripple.com/Tools/UnUUID/ https://realityripple.com/Tools/UnUUID/