Skip to content

Instantly share code, notes, and snippets.

@remarkablemark

remarkablemark/BIN_TO_UUID.sql

Last active January 2, 2022 22:02
Show Gist options
  • Save remarkablemark/4fd35e940984440228e127210eb4fbd9 to your computer and use it in GitHub Desktop.
Save remarkablemark/4fd35e940984440228e127210eb4fbd9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
BIN_TO_UUID.sql
DELIMITER //
CREATE FUNCTION BIN_TO_UUID(bin BINARY(16))
RETURNS CHAR(36) DETERMINISTIC
BEGIN
DECLARE hex CHAR(32);
SET hex = HEX(bin);
RETURN LOWER(CONCAT(LEFT(hex, 8), '-', MID(hex, 9, 4), '-', MID(hex, 13, 4), '-', MID(hex, 17, 4), '-', RIGHT(hex, 12)));
END; //
DELIMITER ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment