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.