Skip to content

Instantly share code, notes, and snippets.

@ronaldbradford

ronaldbradford/uuid-8.0.sql

Created September 28, 2016 19:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ronaldbradford/24654e5405af1907e0c6e3260e4b3dd0 to your computer and use it in GitHub Desktop.
Save ronaldbradford/24654e5405af1907e0c6e3260e4b3dd0 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
uuid-8.0.sql
SELECT IS_UUID(1);
SET @uuid='aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee';
SELECT IS_UUID(@uuid) AS is_uuid;
SELECT IS_UUID(REPLACE(@uuid,'-','')) AS is_uuid;
SELECT @uuid_bin := UUID_TO_BIN(@uuid) AS uuid_bin, LENGTH(@uuid_bin) AS len;
SELECT @old_uuid_bin := UNHEX(REPLACE(@uuid,'-','')) AS old_uuid_bin, LENGTH(@old_uuid_bin) AS len;
SELECT @uuid_bin = @old_uuid_bin;
SELECT BIN_TO_UUID(@uuid_bin) AS uuid, HEX(@old_uuid_bin) AS uuid_old;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment