Skip to content

Triple-networks

Rudger Gravestein

  • Home
  • Blog
  • Portfolio
  • Magento
  • Uptime
  • Contact

Tag: UUID

UUID storage in MySQL

TLDR;

You can store a UUID safely as a “Binary 16”, instead of a “Varchar 36”.

If you still require a human-readable column, its possible to use a “generated” column (from MySQL 5.7 and up):

Source: https://mysqlserverteam.com/storing-uuid-values-in-mysql-tables/

additional info for MySQL 8.0 – https://mysqlserverteam.com/mysql-8-0-uuid-support/

Share this:

  • Click to share on Facebook (Opens in new window) Facebook
  • Click to share on LinkedIn (Opens in new window) LinkedIn
  • Click to share on X (Opens in new window) X

Like this:

Like Loading...
Author RudgerPosted on 15 January 202015 January 2020Categories Code, DevelopmentTags MySQL, storage, UUIDLeave a comment on UUID storage in MySQL
  • View rudgergravestein’s profile on LinkedIn
  • View Rud5G’s profile on GitHub

Recent Posts

  • IAM Permission Boundaries
  • AWS Shared Responsibility Model
  • Types of API pagination
  • A must read about color
  • Introduction to D-Bus

Top Posts

  • Fred Wilsons 10 golden principles of successful web apps
  • Docker. How to get bash\ssh inside running container (run -d)?

Receive notifications of new posts by mail.

  • Home
  • Blog
  • Portfolio
  • Magento
  • Uptime
  • Contact
Triple-networks Proudly powered by WordPress
%d