I'm not finding a way to use JSON_INSERT in a json whose key is a string:
{
"computer": {
"display": blue
},
"computer home":{}
}
This way it works:
JSON_INSERT(type, '$.computer.color', 'red');`
But not like this:
JSON_INSERT(type, '$.computer home.color', 'red');`
My wish:
{
"computer" :{
"display": "blue",
"color": "red"
},
"computer home":{
"color": "red"
}
}
Apparently it's not working because the json key "computer home" has space, how can I insert it even with spaces?