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), '-','')


  • 精彩推荐

  • 2020-12-27 20:36:10

    音频播放AudioTrack之入门篇

    AudioTrack是管理和播放单一音频资源的类。AudioTrack仅仅能播放已经解码的PCM流，用于PCM音频流的回放。