mysql 生成雪花ID sql 亲自验证通过

UPDATE
  ulcd_biz_draft_arrange
SET
  draft_data = JSON_SET( draft_data, '$.id',
  CONCAT( FLOOR(
      REPLACE (
        unix_timestamp(CURRENT_TIMESTAMP (5)),
        '.',
        ''
      )
    ) * 10000 + FLOOR(RAND() * 10000),''
  )),
  update_time = now()
where
  id in (1392751994397282305,
1392751996179861505)