mysql批量补充uuid， Function UUID() and REPLACE(), can't work together

2019-01-02 19:10:50

参考 mysql批量补充uuid

2.补全uuid


update user u

inner join (select id, replace(uuid(),"-","") uuid from user ) r on r.id = u.id

SET u.uuid = r.uuid

where u.uuid = '' or u.uuid is null


当mysql字符集编码为uftmp4，查询replace(uuid(),"-","")一致，就是所有的uuid经过replace都会成相同的uuid

解决办法

replace(convert(uuid() using utf8mb4), '-','')


  • 精彩推荐

  • 2023-08-19 18:57:08

    强制杀死nginx进程简单粗暴

    nginx: [error] open() "/run/nginx.pid" failed (2: No such file or directory)，最简单的办法，杀死nginx进程，重启