【mysql、excel生成uuid格式总结】

﹏ヽ暗。殇╰゛Y 2023-09-24 18:46 76阅读 0赞

### MySQL ###

1、生成 有 - 的格式： 56b48f51-add0-11ed-9963-fa173e8e8ca0

select UUID() as uuid

![在这里插入图片描述][2c0bff8d9cb24cffa33a1fc07db996ab.png]  
2、生成不含 - 的格式：8ada3ef8add011ed9963fa173e8e8ca0

select replace(uuid(),"-","") as uuid;

![在这里插入图片描述][84a6bb20871942dba6e9f1928e5f5dc6.png]  
3、insert使用：

INSERT INTO t_table (`id`,`name`) VALUES (REPLACE(UUID(),"-",""),'张三');

### Excel ###

1、Excel生成uuid 格式：600d65bc-948a-1260-2217-fd8dfeebb1cs

=LOWER(CONCATENATE(DEC2HEX(RANDBETWEEN(0,POWER(16,8)),8),"-",DEC2HEX(RANDBETWEEN(0,POWER(16,4)),4),"-","4",DEC2HEX(RANDBETWEEN(0,POWER(16,3)),3),"-",DEC2HEX(RANDBETWEEN(8,11)),DEC2HEX(RANDBETWEEN(0,POWER(16,3)),3),"-",DEC2HEX(RANDBETWEEN(0,POWER(16,8)),8),DEC2HEX(RANDBETWEEN(0,POWER(16,4)),4)))

2、Excel生成去除横杠uuid 格式（获取小写的32位随机ID：）：600d65bc948a12602217fd8dfeebb1cs

=LOWER(CONCATENATE(DEC2HEX(RANDBETWEEN(0,POWER(16,8)),8),"",DEC2HEX(RANDBETWEEN(0,POWER(16,4)),4),"","4",DEC2HEX(RANDBETWEEN(0,POWER(16,3)),3),"",DEC2HEX(RANDBETWEEN(8,11)),DEC2HEX(RANDBETWEEN(0,POWER(16,3)),3),"",DEC2HEX(RANDBETWEEN(0,POWER(16,8)),8),DEC2HEX(RANDBETWEEN(0,POWER(16,4)),4)))

3、获取大写的32位随机ID：

=UPPER(CONCATENATE(DEC2HEX(RANDBETWEEN(0,POWER(16,8)),8),"",DEC2HEX(RANDBETWEEN(0,POWER(16,4)),4),"","4",DEC2HEX(RANDBETWEEN(0,POWER(16,3)),3),"",DEC2HEX(RANDBETWEEN(8,11)),DEC2HEX(RANDBETWEEN(0,POWER(16,3)),3),"",DEC2HEX(RANDBETWEEN(0,POWER(16,8)),8),DEC2HEX(RANDBETWEEN(0,POWER(16,4)),4)))

4、生成16位UUID（默认为大写）：

=CONCATENATE(DEC2HEX(RANDBETWEEN(0,POWER(16,8)),8),DEC2HEX(RANDBETWEEN(0,POWER(16,8)),8))

5、生成8位的随机ID

=CONCATENATE(IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*9+48)),IF(INT(RAND()*2)=0,CHAR(INT(RAND()*25+65)),CHAR(INT(RAND()*25+97)))))

参考链接1：[https://blog.csdn.net/weixin\_43423864/article/details/124338402][https_blog.csdn.net_weixin_43423864_article_details_124338402]  
参考链接2：[https://blog.csdn.net/u010164507/article/details/109098962][https_blog.csdn.net_u010164507_article_details_109098962]

[2c0bff8d9cb24cffa33a1fc07db996ab.png]: https://img-blog.csdnimg.cn/2c0bff8d9cb24cffa33a1fc07db996ab.png
[84a6bb20871942dba6e9f1928e5f5dc6.png]: https://img-blog.csdnimg.cn/84a6bb20871942dba6e9f1928e5f5dc6.png
[https_blog.csdn.net_weixin_43423864_article_details_124338402]: https://blog.csdn.net/weixin_43423864/article/details/124338402
[https_blog.csdn.net_u010164507_article_details_109098962]: https://blog.csdn.net/u010164507/article/details/109098962