tableAのrecord1列に登録されているJson形式のデータのうち、property1というプロパティをUpdateしたい場合。
update tableA
set record1 = JSON_MODIFY(record1,'$.property1','更新後の値')
where
More than 1 year has passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme