79557113

Date: 2025-04-05 14:41:41
Score: 1
Natty:
Report link

remove syntax in MySQL when working with int value in the array

UPDATE jsontesting
SET jsondata= (
    SELECT JSON_ARRAYAGG(value)
    FROM JSON_TABLE(
        jsondata,
        '$[*]' COLUMNS (
            value INT PATH '$'
        )
    ) AS jt
    WHERE value != 7
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (1):
Posted by: Mahmud Abubakar