I am posting this so I can find it again, if others find it useful that is good too. Define Primary Key as CHAR(36) NOT NULL DEFAULT ‘0’ Define a trigger CREATE DEFINER=`root`@`localhost` TRIGGER `<TableName>_CreateUUIDPrimaryKey` BEFORE INSERT ON `<TableName>` FOR EACH ROW BEGIN set NEW.<PrimaryKeyFieldName> = UUID(); END Example: CREATE TABLE `TestTable` ( […]
-
logon:
-
visitors:
-
- Journalized Theme Copyright © 2002–2024 Mike Little.
