20.0のようになってしまうのを防ぐ方法
roundやfloorなどではダメで、castを使う必要がある
update table_name
set json_column = JSON_REPLACE(
json_column,
"$.field_name", cast(json_column -> '$.field_name' + 1234567 as signed))
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