Collections:
JSON_PRETTY() - Validating JSON Value
How to encode a JSON (JavaScript Object Notation) value into a pretty-printing string using the JSON_PRETTY() function?
✍: FYIcenter.com
JSON_PRETTY(json) is a MySQL built-in function that encodes a JSON (JavaScript Object Notation) value into a pretty-printing string. For example:
SELECT JSON_PRETTY('["a",1,{"key1": "value1"},"5","77",{"key2": ["value3","valueX", "valueY"]},"j", "2"]'); -- +------------------------------------------------------------+ -- | JSON_PRETTY('["a",1,{"key1": "value1"},"5","77",{"key2": ["value3","valueX", "valueY"]},"j", "2"]') | -- +------------------------------------------------------------+ [ "a", 1, { "key1": "value1" }, "5", "77", { "key2": [ "value3", "valueX", "valueY" ] }, "j", "2" ] -- +------------------------------------------------------------+
Reference information of the JSON_PRETTY() function:
JSON_PRETTY(json): str Encodes a JSON (JavaScript Object Notation) value into a pretty-printing string. Arguments, return value and availability: json: Required. The JSON value to be encoded str: Return value. The pretty-printing JSON encoded string. Available since MySQL 5.7.
⇒ JSON_QUOTE() - Quoting JSON String
⇐ JSON_OVERLAPS() - Checking JSON Overlaps
2023-12-10, 288🔥, 0💬
Popular Posts:
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the...