dr41d45
🌴
dr41d45
/ gist:73965172405754b2ed7507c9a72a071e
Created
August 27, 2021 07:48
— forked from jamesgmarks/gist:56502e46e29a9576b0f5afea3a0f595c
MySQL/MariaDB BIN_TO_UUID and UUID_TO_BIN Polyfill
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| DELIMITER // | |
| CREATE FUNCTION BIN_TO_UUID(b BINARY(16)) | |
| RETURNS CHAR(36) | |
| BEGIN | |
| DECLARE hexStr CHAR(32); | |
| SET hexStr = HEX(b); | |
| RETURN LOWER(CONCAT( | |
| SUBSTR(hexStr, 1, 8), '-', | |
| SUBSTR(hexStr, 9, 4), '-', |