Episode-051 - Adding a Check Constraint for JSON in MySQL

Author: MySQL - Bewertung: 1x - Views:1

Check constraints can be used to enforce business rules when storing data. We can use these constraints to validate that a JSON document matches a specific schema. This video shows how to define a check constraint for JSON when creating a table.

Check Constraint Documentation - https://dev.mysql.com/doc/refman/8.0/en/create-table-check-constraints.html

JSON_SCHEMA_VALID() Documentation - https://dev.mysql.com/doc/refman/8.0/en/json-validation-functions.html#function_json-schema-valid