我应该如何在 MySQL 表中存储 GUID?
我是使用 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.
相关文章