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, 281🔥, 0💬
Popular Posts:
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...