Skip to content

Instantly share code, notes, and snippets.

@jeffjohnson9046

jeffjohnson9046/uuid-to-varbinary-16.sql

Created November 16, 2016 17:06
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 jeffjohnson9046/f1aac6f808618dd47ed648f67ff0f5d3 to your computer and use it in GitHub Desktop.
Save jeffjohnson9046/f1aac6f808618dd47ed648f67ff0f5d3 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL - Generate a UUID and convert it to VARBAINARY(16) for storage
Raw
uuid-to-varbinary-16.sql
SELECT UNHEX(REPLACE(UUID(),'-',''))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment