Syntax

    2. mysql> select *,array_difference(k2) from array_type_table;
    3. +------+-----------------------------+---------------------------------+
    5. +------+-----------------------------+---------------------------------+
    6. |    1 | [NULL]                      | [NULL]                          |
    7. |    2 | [1, 2, 3]                   | [0, 1, 1]                       |
    9. |    4 | [0, 1, 2, 3, NULL, 4, 6]    | [0, 1, 1, 1, NULL, NULL, 2]     |
    10. |    5 | [1, 2, 3, 4, 5, 4, 3, 2, 1] | [0, 1, 1, 1, 1, -1, -1, -1, -1] |
    11. +------+-----------------------------+---------------------------------+