mercredi 8 avril 2020

expression for random uuid?

Mysql offers a UUID() function, which returns an rfc 4122 version 1 guid. This is an easily guessed timestamp + node_id bit string.

How may we insert randomized version 4 guids?

(Defining a new function requires permissions and is out-of-scope. Ben Johnson offers an expression that is very nice but a little verbose.)




Aucun commentaire:

Enregistrer un commentaire