How should I store GUID in MySQL tables?

by

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…

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

More Related Contents:

  1. How to store uuid as number?
  2. UUID performance in MySQL?
  3. How to generate a UUIDv4 in MySQL?
  4. Would it help to add index to BIGINT column in MySQL?
  5. How to get a ranking result for special record in mysql [closed]
  6. SQL Query needed for fetch value from Two identical table but not fully identical table
  7. MySQL ERROR 1045 (28000): Access denied for user ‘bill’@’localhost’ (using password: YES)
  8. How to reset AUTO_INCREMENT in MySQL
  9. MySQL Query GROUP BY day / month / year
  10. How do I change the data type for a column in MySQL?
  11. How do I use on delete cascade in mysql?
  12. How to access remote server with local phpMyAdmin client?
  13. How to copy data from one table to another new table in MySQL?
  14. How to connect mysql workbench to running mysql inside docker?
  15. Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’
  16. Calculate the time difference between of two rows
  17. MySQL/Writing file error (Errcode 28)
  18. MySQL Group By and Sum total value of other column
  19. MySQL : Multiple row as comma separated single row
  20. Regaining access to lost MySQL password for PHPMyAdmin on WAMP
  21. Return a default value if single row is not found
  22. How to find out the MySQL root password
  23. SQL search multiple values in same field
  24. Removing duplicates with unique index
  25. Getting number of rows inserted for ON DUPLICATE KEY UPDATE multiple insert?
  26. ALTER table – adding AUTOINCREMENT in MySQL
  27. Does MySQL foreign_key_checks affect the entire database?
  28. AWS Aurora MySQL serverless: how to connect from MySQL Workbench
  29. How to store data with dynamic number of attributes in a database
  30. MySQL Auto increment primary key increases by 10

Leave a Comment