Collections:
JSON_DEPTH() - Calculating Depth of JSON Value
How to calculate the depth of a JSON (JavaScript Object Notation) value using the JSON_DEPTH() function?
✍: FYIcenter.com
JSON_DEPTH(json) is a MySQL built-in function that calculates the depth of a JSON (JavaScript Object Notation) value using the following rules:
For example:
SELECT JSON_DEPTH('{}'), JSON_DEPTH('[]'), JSON_DEPTH('true'); -- +------------------+------------------+--------------------+ -- | JSON_DEPTH('{}') | JSON_DEPTH('[]') | JSON_DEPTH('true') | -- +------------------+------------------+--------------------+ -- | 1 | 1 | 1 | -- +------------------+------------------+--------------------+ SELECT JSON_DEPTH('[10, 20]'), JSON_DEPTH('[[], {}]'); -- +------------------------+------------------------+ -- | JSON_DEPTH('[10, 20]') | JSON_DEPTH('[[], {}]') | -- +------------------------+------------------------+ -- | 2 | 2 | -- +------------------------+------------------------+ SELECT JSON_DEPTH('[10, {"a": 20}]'), JSON_DEPTH('[10, {"a": [10]}]'); -- +-------------------------------+---------------------------------+ -- | JSON_DEPTH('[10, {"a": 20}]') | JSON_DEPTH('[10, {"a": [10]}]') | -- +-------------------------------+---------------------------------+ -- | 3 | 4 | -- +-------------------------------+---------------------------------+
Reference information of the JSON_DEPTH() function:
JSON_DEPTH(json): int Calculates the depth of a JSON (JavaScript Object Notation) value, which is the length of the path that reaches its deepest child member. Arguments, return value and availability: json: Required. The JSON value to be measured. int: Return value. The depth of the JSON value. Available since MySQL 5.7.
⇒ JSON_EXTRACT() - Exacting Members from JSON
⇐ JSON_CONTAINS_PATH() - Finding Path in JSON
2023-12-12, 261🔥, 0💬
Popular Posts:
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...