Navicat中設(shè)置id主鍵默認(rèn)UUIDS

設(shè)置表主鍵id默認(rèn)32位隨機(jī)字符串

1.先創(chuàng)建UUIDS()函數(shù)

CREATE DEFINER=`root`@`%` FUNCTION `UUIDS`() RETURNS varchar(40) CHARSET utf8mb4
RETURN(SELECT REPLACE(UUID(),'-',''))

2.設(shè)計(jì)表添加觸發(fā)器如下

BEGIN
SET new.id = UUIDS();
END