msyql update相关知识点

1. mysql update varchar存储类型的 ["1","2"]更新为["1","2","3"]

UPDATE project_business a
SET a.`company_tag` = JSON_ARRAY_APPEND(company_tag, '$', '3')
WHERE a.id=3237;

注：upate的字段不能为NULL，只能为[]或者中括号里面有值