How can I use the check statement to check the value of a field in mysql?

Question

How can I use the 'Check' statement to check the value of a field in mysql?

look at the page , the manual did not discuss keyword verification

In MySql Workbench and Navicat for mysql, there are no options for setting limits or checking.

Answer 1

MySQL does not apply CHECK restrictions. He analyzes the suggestion of a check constraint but silently ignores it. You will need to use a trigger to validate the data.