How add to json varible a new element in mySQLFrom this: Value = ['123'] Make this: Value = ['123','456']
6kkfgxo01#
JSON_ARRAY_APPEND() function
SET @Value = '["123"]'; SET @Value = JSON_ARRAY_APPEND(@Value, '$', '456'); SELECT @Value;
fiddle
1条答案
按热度按时间6kkfgxo01#
JSON_ARRAY_APPEND() function
fiddle