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, 274🔥, 0💬
Popular Posts:
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...