如何将GUID存储在MySQL表中? [英] 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问我为什么在4中可以做同样的事情时为什么需要存储16个字节带整数的字节.自从他向我提出挑战以来，我认为现在是提起挑战的好时机.话虽这么说...

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.

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