Re:Do Not Recommend: User Provided Primary Keys
by evanelias on Thursday February 24, 2022 @10:10PM
(#30463319)
MySQL doesn't have a native uuid column type, but it does provide conversion functions UUID_TO_BIN() [1] and BIN_TO_UUID() [2]. These also have a convenient optional "time swapping" flag, to improve insertion order / btree efficiency.
[1] https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-functi...
[2] https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-functi...