CHECK constraint in MySQL is not working
MySQL 8.0.16 is the first version that supports CHECK constraints. Read https://dev.mysql.com/doc/refman/8.0/en/create-table-check-constraints.html If you use MySQL 8.0.15 or earlier, the MySQL Reference Manual says: The CHECK clause is parsed but ignored by all storage engines. Try a trigger… mysql> delimiter // mysql> CREATE TRIGGER trig_sd_check BEFORE INSERT ON Customer -> FOR EACH ROW -> BEGIN … Read more