json added to MySQL
P粉939473759
P粉939473759 2024-04-04 19:17:30
0
1
357

How to add new elements to json variables in mySQL

thus: value = ['123'] Do this: Value = ['123','456']

P粉939473759
P粉939473759

reply all(1)
P粉464088437

JSON_ARRAY_APPEND() ; Function

SET @Value = '["123"]';
SET @Value = JSON_ARRAY_APPEND(@Value, '$', '456');
SELECT @Value;
@Value
["123", "456"]

violin

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!