|
Functions unique for MariaDB:
JSON_COMPACT
JSON_LOOSE
JSON_DETAILED
They are all 'cosmetic' functions. They don't change the JSON, only add or remove spaces to make it look better in some sence.
JSON_COMPACT removes all the unnecessary spaces so the json string is as short as possible.
JSON_LOOSE - adds some spaces to make json look a bit more readable. That representation is what MySQL returns.
JSON_DETAILED(json [, tab_size]) represents JSON in most understandable way emphasizing nested structures.
|