List:General Discussion« Previous MessageNext Message »
From:sean c peters Date:September 16 2005 7:16pm
Subject:UUIDs - first usage for me
View as plain text  
Hi all, 
Im researching switching a production database system to use UUID's instead of 
AUTO_INCREMENT columns for various ids. I've looked at various MySQL 
documentation, and it seems to be what i want. 
This change will really affect 2 separate database servers. Both are using 
InnoDB tables. One is running MySQL 4.1.3-beta on solaris, and the other is 
running 4.1.8-Max on Redhat Linux. 

From what i've been reading, the only thing i cant determine is what column 
type to use to store the UUID's. These will be foreign keys between some 
tables, and the unique ids in all tables for this system. 

Should i be using BINARY() columns ?

Thanks much

-- 
Sean Peters
Senior Programmer, WIREData Inc.
speters@stripped

"The software required Windows 2000 or better, so i Downloaded Linux"

Thread
UUIDs - first usage for mesean c peters16 Sep
  • Re: UUIDs - first usage for meGleb Paharenko17 Sep
    • Re: UUIDs - first usage for meChristian Parpart17 Sep
      • Re: UUIDs - first usage for meGleb Paharenko17 Sep
      • Re: UUIDs - first usage for meDan Nelson17 Sep
        • Re: UUIDs - first usage for meChristian Parpart21 Sep