I can do it in the command line, however, I can't find the option to add a check constraint in Mysql Workbench. I can only find triggers, but not check constraints.
MySQL allows the syntax for check constraint, but doesn't do anything about it. Hence, no checks.
This will ensure that only valid colors are allowed. If you do this when the table is created, you can add NOT NULL.
Not the answer you're looking for? Browse other questions tagged mysql mysql-workbench check-constraints or ask your own question.