我应该如何在 MySQL 表中存储 GUID? [英] How should I store GUID in MySQL tables?

问题描述

我是使用 varchar(36) 还是有更好的方法?

Do I use varchar(36) or are there any better ways to do it?

推荐答案

当我问到为我的对象存储 GUID 的最佳方法时，我的 DBA 问我为什么我需要存储 16 个字节，而我可以在 4 个字节中做同样的事情带整数的字节.既然他向我提出了那个挑战，我认为现在是提它的好时机.话虽这么说...

My DBA asked me when I asked about the best way to store GUIDs for my objects why I needed to store 16 bytes when I could do the same thing in 4 bytes with an Integer. Since he put that challenge out there to me I thought now was a good time to mention it. That being said...

如果您想最优化地利用存储空间，您可以将 guid 存储为 CHAR(16) 二进制文件.

You can store a guid as a CHAR(16) binary if you want to make the most optimal use of storage space.

这篇关于我应该如何在 MySQL 表中存储 GUID?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！