|
|
MariaDB 10.2
|
MariaDB [test]> SET @j = '["a", {"b": [1, 2]}, [3, 4]]';
|
Query OK, 0 rows affected (0.00 sec)
|
|
MariaDB [test]> SELECT JSON_ARRAY_INSERT(@j, '$[2][1]', 'y');
|
+---------------------------------------+
|
| JSON_ARRAY_INSERT(@j, '$[2][1]', 'y') |
|
+---------------------------------------+
|
| ["a", {"b": [1, 2]}, [3,, "y" 4]] |
|
+---------------------------------------+
|
1 row in set (0.00 sec)
|
|
MySQL 5.7
|
MySQL [test]> SET @j = '["a", {"b": [1, 2]}, [3, 4]]';
|
Query OK, 0 rows affected (0.00 sec)
|
|
MySQL [test]> SELECT JSON_ARRAY_INSERT(@j, '$[2][1]', 'y');
|
+---------------------------------------+
|
| JSON_ARRAY_INSERT(@j, '$[2][1]', 'y') |
|
+---------------------------------------+
|
| ["a", {"b": [1, 2]}, [3, "y", 4]] |
|
+---------------------------------------+
|
1 row in set (0.00 sec)
|
|