JSON array format in MySQL not working?
Are you attempting to insert a JSON array with two objects, Test1
and Test2
?
If so, then you need to insert the data as an array:
JSON array:
[{
"Test1": {
"Val1": "37",
"Val2": "25"
}
}, {
"Test2": {
"Val1": "25",
"Val2": "27"
}
}]
Your INSERT
statement would look similar to the following (note the wrapping brackets around the JSON objects):
INSERT INTO zz_TEST_ObsJSON (jsonData) values ('[{"Test1":{"Val1":"37", "Val2":"25"}},{"Test2":{"Val1":"25", "Val2":"27"}}]');