How to add new elements to json variables in mySQL
thus: value = ['123'] Do this: Value = ['123','456']
1
0
0
JSON_ARRAY_APPEND() ; Function
SET @Value = '["123"]'; SET @Value = JSON_ARRAY_APPEND(@Value, '$', '456'); SELECT @Value;
| @Value |
|---|
| ["123", "456"] |
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
