Skip to content

Instantly share code, notes, and snippets.

@myalban

myalban/UUID_TO_BIN.sql

Forked from remarkablemark/UUID_TO_BIN.sql
Created January 2, 2022 22:03
Show Gist options
  • Save myalban/881fa90f61a94bcb008bb459d76db84f to your computer and use it in GitHub Desktop.
Save myalban/881fa90f61a94bcb008bb459d76db84f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
UUID_TO_BIN.sql
DELIMITER //
CREATE FUNCTION UUID_TO_BIN(uuid CHAR(36))
RETURNS BINARY(16) DETERMINISTIC
RETURN UNHEX(CONCAT(REPLACE(uuid, '-', ''))); //
DELIMITER ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment