Collections:
JSON_SCHEMA_VALID() - JSON Schema Validation
How to validate a JSON value against a JSON schema using the JSON_SCHEMA_VALID() function?
✍: FYIcenter.com
JSON_SCHEMA_VALID(schema, json) is a MySQL built-in function that validates a JSON value against a given JSON schema. For example:
SET @schema = '{ "id": "http://json-schema.org/geo", "$schema": "http://json-schema.org/draft-04/schema#", "description": "A geographical coordinate", "type": "object", "properties": { "latitude": { "type": "number" }, "longitude": { "type": "number" } }, "required": ["latitude", "longitude"] }'; SET @document = '{"latitude": 63.444697, "longitude": 10.445118}'; SELECT JSON_SCHEMA_VALID(@schema, @document); -- +---------------------------------------+ -- | JSON_SCHEMA_VALID(@schema, @document) | -- +---------------------------------------+ -- | 1 | -- +---------------------------------------+ SELECT JSON_SCHEMA_VALID(@schema, '{"latitude": 63.444697}'); -- +-------------------------------------------------------+ -- | JSON_SCHEMA_VALID(@schema, '{"latitude": 63.444697}') | -- +-------------------------------------------------------+ -- | 0 | -- +-------------------------------------------------------+
Reference information of the JSON_SCHEMA_VALID() function:
JSON_SCHEMA_VALID(schema, json): int Returns 1 if the JSON schema meets all requirements defined in the JSON schema. Otherwise it returns 0. Arguments, return value and availability: schema: Required. The JSON schema to validate against. json: Required. The JSON value to be validated. int: Return value. The validation result, 0 or 1. Available since MySQL 8.0.
Related MySQL functions:
⇒ JSON_SCHEMA_VALIDATION_REPORT() - JSON Schema Validation Report
⇐ JSON_REPLACE() - Replacing JSON Child Members
2023-12-15, 280🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...