mysql直接操作数据库表里的json字段的单个值？答案在这里

update ulcd_biz_draft_arrange SET draft_data=json_set(draft_data,’$.position’,80) where id=1374899302506790914

select id,sequence,JSON_EXTRACT( draft_data, ‘$.position’ ) from ulcd_biz_draft_arrange where id=1374899302506790914

UPDATE ulcd_biz_draft_arrange
SET sequence = sequence - 1,
draft_data = json_set( draft_data, ‘$.position’, sequence)
WHERE
id=1374899302506790914