How about the UUID() function. As I recall, the differences between a UUID and Microsoft's GUID are trivial.
INSERT INTO Inv_Id SET id = UUID(); Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -----Original Message----- > From: Martijn Tonies [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 19, 2006 9:45 AM > To: Dan Buettner; Scott Hamm > Cc: Mysql > Subject: Re: Re: CREATE TABLE Inv_Id > > > > > > Scott, what's wrong with 'PRIMARY KEY' ? > > A PRIMARY KEY has nothing to do with the "uniqueidentifier" datatype. > > A "uniqueidentifier" is a GUID. > > Martijn Tonies > Database Workbench - development tool for MySQL, and more! > Upscene Productions > http://www.upscene.com > My thoughts: > http://blog.upscene.com/martijn/ > Database development questions? Check the forum! > http://www.databasedevelopmentforum.com > > > > > On 10/19/06, Scott Hamm <[EMAIL PROTECTED]> wrote: > > > Wish MySQL would have something like what Microsoft use, > "uniqueidentifier" > > > as datatype. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
