mysql、excel生成uuid格式总结

最新推荐文章于 2024-07-08 07:30:00 发布

一起码代码

最新推荐文章于 2024-07-08 07:30:00 发布

阅读量4.6k

点赞数 6

分类专栏：小功能小工具小demo JAVA 文章标签： mysql 数据库

本文链接：https://blog.csdn.net/weixin_43423864/article/details/124338402

版权

JAVA 同时被 2 个专栏收录

44 篇文章 3 订阅

订阅专栏

小功能小工具小demo

2 篇文章 0 订阅

订阅专栏

Mysql

1、生成有 - 的格式： e3d7387a-c1df-11ec-ac0a-525400625d29

 select UUID() as uuid

在这里插入图片描述
2.生成不含 - 的格式：1dd13e56c1e011ecac0a525400625d29

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

在这里插入图片描述
3.insert 使用

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

Excel

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

=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 格式：600d65bc948a12602217fd8dfeebb1cd

=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)))