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

Skip ad
Current Time 0:00
Duration -:-
Loaded: 0%
Stream Type LIVE
Remaining Time -:-
 
1x
8 Views

  • Thanks! Share it with your friends!

    You disliked this video. Thanks for the feedback!

mysql
Published
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
Category
MySQL
Tags
MySQL, Database, Open-source
Be the first to comment