how to update json key name while keeping the values in mysql

Solutions on MaxInterview for how to update json key name while keeping the values in mysql by the best coders in the world

Search
showing results for - "how to update json key name while keeping the values in mysql"
Olivier
03 Jan 2017
1UPDATE `my_table` 
2SET `my_col` = JSON_INSERT(
3                           JSON_REMOVE(my_col, '$.oldKeyValue'), 
4                           '$.newKeyValue', 
5                           JSON_EXTRACT(my_col, '$.oldKeyValue')
6                          );
7
source
similar questions
mysql json change keymysql json get valuejson rename keyupdating json object in mysql databaseupdate data in json using javascriptjsonb set remove keyupdate table remove a key from json object mysqlpostgresql update json field key valueuse jq to update json filemysql get json value by key
queries leading to this page
mysql update json column key with json objectmysql how to update json field 281 29 is there a benefit for being able to store json data in a mysql column 3f explain your opinion in a few sentences how to update json oject key in mysqlmysql json key name updatehow to update a key in json stored in mysqlhow to update json key name while keeping the values in mysqlupdate mysql column with json valueupdate json field key value in mysqlbenefit for being able to store json data in a mysql columnmysql update json key valuemysql how to update json whole fieldupdate json key value in mysqlhow to update json key name while keeping the values in mysql