[Solved] How to use UniqueIdentifier data type in MySql database

In MySql there is no UniqueIdentifier data-type. But you can still use it by creating a field of type CHAR(38) as length of UniqueIdentifier is 38 characters.

CREATE TABLE `sample` (
  `Uid` char(38) NOT NULL,
  PRIMARY KEY (`Uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Then in order to get random UniqueIdentifier value. You can make use of UUID() function of MySql which is similar to NEWID() of Sql Server.

INSERT INTO Sample(UId)
VALUES(UUID());
SELECT * FROM Sample;

Screenshot