MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE `testStuff` (
    `j_object` json NOT NULL
)
SET @post_body := '
{
    "test": [
        {
            "id": 20,
            "name": "John Doe",
            "location": "NY"
        },
        {
            "id": 21,
            "name": "Betty Doe",
            "location": "FL"
        }
    ]
}
'
INSERT INTO testStuff (j_object)
SELECT value
FROM JSON_TABLE(@post_body, '$.test[*]' COLUMNS (value JSON PATH '$')) jsontable

Records: 2  Duplicates: 0  Warnings: 0


SELECT CAST(j_object AS CHAR) FROM testStuff


CAST(j_object AS CHAR)


{"id": 20, "name": "John Doe", "location": "NY"}

{"id": 21, "name": "Betty Doe", "location": "FL"}