需要用Excel导入数据库数据,数据库有个主键ID是UUID的,需要先使用Excel生成UUID 查到多种UUID的格式的方式整理如下: 1、Excel生成guid,uuid  格式是小写的字母带有横线,如: =LOWER(CONCATENATE(DEC2HEX(RANDBETWEEN(0,POWER(16,8)),8),"-",DEC2HEX(RANDBETWEEN(0,POWER(16,4)),4),"-","4",DEC2HEX(RANDBETWEEN(0,POWER(16,3)),3),"-",DEC2HE…

2022-09-17 0条评论 21点热度 0人点赞 admin 阅读全文