Navicat中设置id主键默认UUIDS
设置表主键id默认32位随机字符串
1.先创建UUIDS()函数
CREATE DEFINER=`root`@`%` FUNCTION `UUIDS`() RETURNS varchar(40) CHARSET utf8mb4
RETURN(SELECT REPLACE(UUID(),'-',''))
2.设计表添加触发器如下
BEGIN
SET new.id = UUIDS();
END
CREATE DEFINER=`root`@`%` FUNCTION `UUIDS`() RETURNS varchar(40) CHARSET utf8mb4
RETURN(SELECT REPLACE(UUID(),'-',''))
BEGIN
SET new.id = UUIDS();
END