Skip to main content

CHECK Constraint

Learn CHECK Constraint (Constraints, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction A CHECK constraint is a boolean rule every row must satisfy. MySQL 8.0.16 and later enforce it; older versions parsed and ignored it, a common source of confusion. A row is rejected when the condition is FALSE; when it evaluates to NULL (UNKNOWN) the row is accepted.

More lessons in Constraints